Excel Training Videos Home

Highlighting Duplicates in Excel Data

In the video on tips in Excel we had demonstrated how to find and format duplicates and highlight them.
Today let's use conditional formatting on our data to highlight duplicates in a more intuitive manner.
Let's say your club is issuing tickets to its members and wishes to avoid duplicates:
  1. Select the data
  2. Click on 'styles' in the home tab
  3. Select Condtional formatting
  4. Select Highlight Cells Rules
  5. Click on duplicate values
  6. In the 'duplicate values' window, select duplicate and define the formatting colors by choosing an appropriate color value from 'values with'
  7. You can also select a 'custom format..' and proceed accordingly.
  8. You can remove the formatting by selecting all the cells used in the formatting procedure, click on the styles drop down arrow, select 'clear rules' and finally 'clear rules from selected cells.

Further Reading
Highlighting Duplicates in Excel Data