Excel VBA to highlight/update other cells on change of value in one

Опубликовано: 17 Октябрь 2024
на канале: Extreme Automation - Kamal Girdher
6,627
26

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.