use Conditional Formatting

select the two columns and set the formula
=(A1<B1)




"nomi" wrote:

I have two columns of dates. one is right and other has some missing values.
I would like to write a macro that compare the two columns and colured(red)
those dates(cells/rows) that are not same