Actually, maybe it did. I crashed Excel, but after recovery, I think it may
have worked. Thanks

"Toppers" wrote:

Haven't got 2007 but highlight both columns and set CF:


FormulaIs: =$A1<$B1


HTH

"Frank" wrote:

Hello,
In Excel 2003, I would use CF to compare two columns of numbers. Assuming
colA and colb had the numbers, I would put the following CF in cell B1:
=if(a1<b1,1,0) and format the cell with a red background. This would tell
me when the values were not equal. I could then copy that formatting down
the column and it would highlight any cell that was variant.

Trying to do that in 2007 and am being caught by the absolute reference. I
try and take it off, but the formula does not change. For example, every
cell in column B looks at the comparison of B1 to A1, and the CF is applied
to the whole column.

I'm sure it is something basic I am missing, but cannot figure it out. Any
help would be appreciated.