conditional formatting in excel 2007

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
 
E

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top