How to Highlight Excel Duplicates in a Flash

The new “Remove Duplicates” command in Excel 2007 does not offer a step by step wizard so you can decide which data to delete.

Decide yourself which duplicates need to be deleted or which need special treatment. It is very easy…

This command is available in Excel 2007.

  1. Go to Home>Styles>Conditional formatting>Highlight Cells Rules>Duplicate values
  2. Choose “Duplicate” and Define the format: predefined or custom
  3. Ok

Step 1

Highlight Excel Duplicates


Step 2


And done…


Are you doing manual work every day in Excel?

Invest 30 minutes today in learning a quickest way to do a thing and save hours in the days to come.