Excel Highlighting duplicates with exact matches

Question

I've got two columns of data, and I would like to use conditional highlighting to find the EXACT matches in both columns. However, using a formula like this one turns up a lot of incorrect matches:

=MATCH(A1,B:B,0)>0

There are a lot of partial matches, so cells are highlighted that I don't want. What I want is the equivalent of the "Match Entire Cell Contents" checkbox in the Find & Replace dialog.

But this only applies to find & replace. How can I update the formula above to work the same way, so that only exact matches to what's in a cell are highlighted?

Answer 1

To enter the Advanced Filter dialogue box, go to the Data menu and pick Filter, then Advanced Filter. In the Action section, choose Copy To Another Location. In the Copy To control, choose a copy range. Select Only Unique Records and click OK.