Dear Experts,

                     I have a scenario , where in Cell R18, I can have value as 11/12 or 13, and

11 -> means in Row-17 0 will get highlighted,

12-> 0,1 will get highlighted and

13-> 0,1,3 will get highlighted, but how to use conditional formatting to use a color format to highlight those cells B17, C17,D17 once they are populated?

Please provide solution with both Format if R18 is a Text and R18 is a number.

Thanks in Advance,

Br,

Anupam

​Dear Experts,                     I have a scenario , where in Cell R18, I can have value as 11/12 or 13, and11 -> means in Row-17 0 will get highlighted,12-> 0,1 will get highlighted and13-> 0,1,3 will get highlighted, but how to use conditional formatting to use a color format to highlight those cells B17, C17,D17 once they are populated? Please provide solution with both Format if R18 is a Text and R18 is a number. Thanks in Advance,Br,Anupam   Read More

​