P
PJS
Hello!
Let say I have a range of data A1
10
Is Excel conditional fomratting able to highlight cell ranges A1
1 to the a
font color of green base on conditions like IF C1 = 0 and IF D2 > C2
and for A2
2 based on a different set of rules like IF C2 = 1 and IF D2 >
C2 ~ highlight the cells A2
2 to a font color of blue, and so on?
Would this require Basic Visual and macros?
Thanks in advance.
PJS
Let say I have a range of data A1
Is Excel conditional fomratting able to highlight cell ranges A1
font color of green base on conditions like IF C1 = 0 and IF D2 > C2
and for A2
C2 ~ highlight the cells A2
Would this require Basic Visual and macros?
Thanks in advance.
PJS