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

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