Highlight Duplicate Values

In this example I will show you how to highlight duplicate values in a column or row in less than 20 seconds.

Here we have a list of names in Column A which contains some duplicate values.

The duplicate value are not easily recognisable but if you add some conditional formatting to the column all the duplicate values can easily be seen. To do this…..

Step 1

Highlight the range of cells that contain the data.

Step 2

In the Home tab select Conditional Formatting >>> HighLight Cells Rules >>> Duplicate Values

Step 3

Select from the dropdown bar whether you want to highlight Duplicate or Unique values in the range.
If required you can customise the text displayed.

Click OK.

All duplicate values in the range will now be highlighted.