conditional formatting in excel 2007

  • Thread starter Thread starter PJS
  • Start date Start date
P

PJS

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,D2>C2), choose color green to fill,
add new rules for your other options

if this helps please click yes, thanks
 
Back
Top