Two cells if no match

[Bill]

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

 

[Norman Jones]

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?

 

[Jim May]

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