Conditional Format Range of Cells

T

tommcbrny

Hi, I am using Excel 2007 and trying to apply conditional formatting as
follows:

If number in column B is greater than number in column D, format text in
column A
If number in column B is less than number in column D, format text in column
C.

So if B1 > C1, format A1, then if B2<C2, format D2, then if B3>C3, format
A3, and so on.

I am able to format text in cell A1 if the number in B1 is greater than C1.
I also figured out how to apply this format to all cells in column A, but
only based on values in B1 & C1.

Is there a way to specify the formual in conditional formatting so that it
compares row by row without entering a new conditional format rule for each
row?

Thank you,
Tom
 
L

Luke M

When you are writing the rule, make sure the row reference is relative ($B3)
and not absolute ($B$3). This will allow the rule to adapt to each row you
copy it to. I'm afraid I don't use 2007 myself, or I would be clearer in my
guidance.
 
T

tommcbrny

I tried doing this, but notice in 2007 that it specifies an absolute
reference by default and goes back to the absolute reference even if I change
to a relative reference and apply the change. As soon as I click "Apply", it
reverts to the absolute reference.

Thank you for the suggestion though.
 
T

tommcbrny

Ah, never mind, I am able to specify the relative reference, that does the
trick. Thank you.
 

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