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.
Work Smarter Not Harder 
Mike, nice tip. I’ve added a link to it from Connexion – our collection of the most useful and interesting spreadsheet-related articles from the web. See http://www.i-nth.com/resources/connexion
LikeLike
Great..thanks Bob!
LikeLike