conditional formatting in excel 2007

[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

 

[Eduardo]

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

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

if this helps please click yes, thanks