Excel compare 2 columns/lists for differences or unique values

Hi Hoover,

Select columns A and B. Click on CF Icon and select Highlight Cells Rules of Duplicate Values. Anything that isn't highlighted is what you want.

I agree with cjs above but fell into the same trap. Some of the values in the A column alone are duplicate. This then invalidates my method.

You need to select UNIQUE values from the CF dropdowns.