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 B3C3, 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