How to Check for Duplicate Records in Excel

1. Click the 'Home' tab.
2. Click 'Conditional Formatting' in the 'Styles' box in the Office ribbon.
3. Select 'Highlight Cell Rules' and then 'Duplicate Values.' The 'Duplicate Values' box will open.
4. Select 'Duplicate' from the drop-down box and choose the color for the highlighted duplicates. Click 'OK.' Excel will show all duplicate values in the color that was chosen.