How to Highlight Duplicate or Unique Values in Excel

If you have the need to highlight cells with duplicate or unique values in Microsoft Excel 2016 or 2013, here’s an easy way to do it.

1. Open the Excel sheet, then select the “Home” tab.
2. Select the “Conditional Formatting” button.
3. Choose “Highlight Cell Rules“.
4. Choose “Duplicate Values…“.
   
5. Now you can choose to highlight “Duplicate” or “Unique“, then choose the color you would like to highlight them with.
   

Your duplicate or unique data will then be marked as desired.