Tech Xpress

Highlight Duplicate Cells in Excel

Finding duplicate values in an Excel spreadsheet can often be painfully boring. But if you know how to do it, its actually quite easy. Here's the way to easily get it done.

How to Highlight Duplicate Cells in Excel 2007 and Excel 2010

1. Select the cells for which you want to find and highlight duplicate values.

2. In the Home tab, go to Conditional Formatting >> Highlight Cells Rules >> Duplicate Values...

3. The Duplicate values box appears. Select the color to apply for duplicate cells. Click Ok.

4. Bingo! The duplicates are now highlighted.

More Tips:
Freeze First Column and Row in Excel
Convert Rows-to-Columns and Columns-to-Rows in Excel

posted by Vijeesh Ravindran, Saturday, October 29, 2011