Highlight Duplicate or Unique Values in Excel

Conditional formatting in Excel can help you easily identify duplicate or unique values in your data set. Here’s how you can highlight these values:

Sample Data

Values
A
B
A
C
D
B
E
A
F
G

Steps to Highlight Duplicate Values

1. Select the range of cells you want to format. [?] Click and drag over the cells to select them.
2. Go to the Home tab in the Ribbon.
3. Click on Conditional Formatting > Highlight Cells Rules > Duplicate Values.
4. Choose the formatting style for the duplicates and click OK.

Steps to Highlight Unique Values

1. Select the same range of cells as above.
2. Again, navigate to Home tab > Conditional Formatting > Highlight Cells Rules > Duplicate Values.
3. In the dialog box, select Unique from the dropdown menu.
4. Choose a formatting style for the unique values and click OK.

Resulting Table

Values
A
B
A
C
D
B
E
A
F
G