Hi

We need some more information.

Do your want to compare two sheets in same workbook or maybe multiple sheets
in two workbooks?

How are your data layout, ie which columns and rows needs to be compared. Do
you want to compare cell by cell or row by row.

Shall only a single cell be highligheted, or maybe the entire column.

Regards,
Per

"compare xl" <compare skrev i meddelelsen
...
Hi,

I would like to have a macro that will compare the contents of two excels
and return the difference in terms of red colors in the target excel.

Thanks in advance,
Santanu