Hi Tommcbrny,

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?

Just select all cells you need the conditional format for and set the formula
up for the selected cell (the white-ish one) using cell references without $
signs in them where appropriate.

So if you are on row 2, set the formulas so they point to the cell(s) on row 2.
Excel will adjust themfor the other cells automatically just like it does when
you copy a formula.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com
Member of:
Professional Office Developer Association
www.proofficedev.com