Quickly highlight unique or duplicate values

Excel 2007, Excel 2013

Highlight the data you want to check.

On the Home menu tab, click on the Conditional Formatting icon.

Select Highlight cell rules and then Duplicate values.

To highlight duplicate values, choose Duplicate from the dropdown and click on the OK button.

The duplicates will be highlighted.

To highlight unique values, choose Unique from the dropdown and click on the OK button.

If the results aren’t quite what you expect, make sure that there are not multiple conditional formats targeting the range.

On the Home menu tab, click on the Conditional Formatting icon and choose Manage Rules