Fill Mismatch Cells

Hi everyone,

I have a table with data in 2 different columns. In the first column there are names of companies given to me by an outside source and they are labeled according to the way this outside company labels them.

In the second coulumn, There are names of the same companies, only this time they are labeled according to the way my company labels them.

What I need to do:

I would like to use a formula or any excel function to find when the company name in the first column is at all different from any name in the second. If the name is different, I would like to receive an alert message, or just fill the cell red if it is easier.

Let me know your thoughts please.

And Thank you in advance!

sample workbook pls

I can't use the real workbook since the data is sensitive. But here is a sample with just 5 rows...The real sheet has data in over 2000 rows however.

Is there any particular logic for naming as per your company? Do you cross check the names from a database? Or is it just human understanding that Coke should be mapped to Coca-Cola..etc? If there is no particular logic in changing the names, none of Excel functions will be able to work this way..