This video is created to explain how to update and highlight other cells based on change in value of one.
I received a query from a viewer. His requirement was :
********************************************************
Came across your YouTube channel, trying to see if you can help in excel.
I am looking at situation of 5 cells, whereby the user can enter numerical value in 1 cell only, once entered the other 4 cells change the colour with a '-' in it. However, if the user wants to change the value in other cell, then the rest 4 cell colour is changed with a '-'.
Checking if you have a video for the same, will be helpful.
********************************************************
Watch this video and hit LIKE if you are happy with the content. And do not forget to subscribe.