- Select the range of cells you think might contain duplicates.
- On the Home tab, select Conditional Formatting > Highlight Cells Rules > Duplicate Values.
- In the Duplicate Values box, make sure the Duplicate is selected in the first drop-down box.
- Then select the format for the duplicate values in the other drop-down box. Select OK.
If you do not already have a group exported to Excel you can use this KB Solution.