ExcelBanter - macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - macro (https://www.excelbanter.com/excel-programming/342152-macro.html)

nomi

macro

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

Patrick Molloy[_2_]

macro

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

All times are GMT +1. The time now is 02:54 AM.