Hi guys,
First time poster here.

I have 2 different columns that I want to compare and highlight the differences.
Theres 547 rows of data in each worksheet, and the letter/number in column A is the same for both of the worksheets, however the data in column B differs. Is there a way to automatically highlight the differences in column B?

Thanks so much,
Let me know if you need examples.