Hey Fan924,

These DO NOT line up line for line. What I need to do, is to use the "key"
from the "dirty" set, then find out what row it matches (if it does) in the
second set of data (I would have this in a diff worksheet, but it seems
conditional format cannot referance another sheet, so I have put all data on
the same sheet). It would then compare each cell in that row of data, to the
clean data row and highlight the differences in the dirty column.

I also don't want to mess with the column structure, as I will want to re
import this back into Outlook.

I was thinking something like
conditional format formula
=if(indirect(address(row(),column()) < indirect(address(match(keyvalue form
dirty row, keycolumn in cleandata, column()+150))
But I have not gotten it to work like I thought it would

Thanks
Mc

"Fan924" wrote in message
...
I do something similar.
I past this function in E2.
=IF(C2=D2," = ","Not =")

Then go to Format menu, Conditional Formatting...
and assigned green to "=", and red to "Not =".