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