Hi,

I have about 10 thousand records. There are two columns that need to
compare each rows.

I need a code to run macro automaticly on Excel to check two columns for
each records and set four colors in each rows based on Column A and Column
B.

Hi Bill,

ghvf aaaa No Match "yellow"
vnmb wwww No Match "Blue"

In the case of no match, how is the choice between yellow and blue to be
determined?

---
Regards,
Norman



"Bill" wrote in message ...
Hi,

I have about 10 thousand records. There are two columns that need to
compare each rows.

I need a code to run macro automaticly on Excel to check two columns for
each records and set four colors in each rows based on Column A and Column
B.

For example:

Column A Column B Comments
qwer qwer Match "no colour"
ghvf aaaa No Match "yellow"
vnmb wwww No Match "Blue"
Blank bbbb No information on
Column A "light grey"
mmmm blank No information on Column B
"green"

Your help would be much appreciated.
Thanks

In C1 enter (and copy down)

=IF(EXACT(B1,A1),"Match",IF(ISBLANK(A1),"No Information in Column
A",IF(ISBLANK(B1),"No Information in Column B","No Match")))

Only 3 Conditional formats are required

Use Cell Value is Equal to
="No Match"

Add 2, and 3

HTH



"Bill" wrote in message ...
Hi,

I have about 10 thousand records. There are two columns that need to
compare each rows.

I need a code to run macro automaticly on Excel to check two columns for
each records and set four colors in each rows based on Column A and Column
B.

For example:

Column A Column B Comments
qwer qwer Match "no colour"
ghvf aaaa No Match "yellow"
vnmb wwww No Match "Blue"
Blank bbbb No information on
Column A "light grey"
mmmm blank No information on Column B
"green"

Your help would be much appreciated.
Thanks