Hello!

Let say I have a range of data A1:D10
Is Excel conditional fomratting able to highlight cell ranges A1:D1 to the a
font color of green base on conditions like IF C1 = 0 and IF D2 C2
and for A2:D2 based on a different set of rules like IF C2 = 1 and IF D2
C2 ~ highlight the cells A2:D2 to a font color of blue, and so on?

Would this require Basic Visual and macros?

Thanks in advance.

PJS