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