Hi,
Highlight the range you want to format
go to conditional formating, new rule, last option, use a formula there enter

=and(C1=0,D2C2), choose color green to fill,
add new rules for your other options

if this helps please click yes, thanks

"PJS" wrote:

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