Excel 2010‘s conditional formatting feature is a super quick and easy way to find duplicate data in your spreadsheets.
How It Works
- Select a range of cells, table, or PivotTable report.
- From the Home tab, in the Styles group, click the arrow next to Conditional Formatting, and then go to Highlight Cells Rules » Duplicate Values…
- Choose the formatting you’d like to apply to the duplicate values and click OK.