Compare two coulmn

**naflas** · 11-24-2010, 09:15 PM

Hi,

I have two columns , Column A and B.

I want to compare column A with B and highlight column B unmatched values in red. Attached is the sample document. In the attached document, Two values in the B column are not exist in column A. So I highlighted them in red.
Comparetwocolumns.xlsx
I have to compare around 1500 rows in the actual document. So the macro should run bit quicker …

**solnajeff** · 11-24-2010, 09:47 PM

Hi

Rather than a macro try conditional formatting, which will change automatically

Please Login or Register  to view this content.

If you enter the above code in the conditional format for cell B1 , set the format you want and then copy and paste special formats for the appropriate number of rows you have the desired result.

Regards

Jeff