Highlighting duplicate or unique values

Highlighting duplicate or unique values

If you have the data in excel that contains a mix of duplicate and unique values and you want to highlight either duplicate or unique values from your data.

This can be done using the "conditional formatting" option. Select the data and then go to Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values.

 

By default, it highlights duplicate values in the selected range, however, the criteria can be changed to unique values from the dialog box that appears.