Fill cells based on the value of other cell

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hi,

Please can you help providing macro for the below query..

If I enter a value in a cell say for example I have entered '2' in B4, i want 2 cells i.e B10 and C10 to be filled with a colour-say yellow. Similarly if I enter '4' in C4 then i want D11 to G11 to be filled with green colour.

Thanks

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You can use conditional format for that