Excel compare 2 columns/lists for differences or unique values

With both columns selected simply click on conditional formatting - highlight cell rules - and then select duplicate values.

I have attached spreadsheet with that enabled.

Is this what you needed?

Ninja edit: If you want to show just the unique cells you can go back into the Conditional Formatting Rules and change it it highlight just unique values instead of highlighting all duplicates.