How to Highlight Duplicates in Excel 2007

By Aksana Nikolai

Many of us have created spreadsheets at work or for personal use, only to realize that the same data appears more than once in the list. You can use the Conditional Formatting feature in Microsoft Excel 2007 to locate and highlighting the duplicate values in a data range. In addition to saving the time needed to manually search the list, this feature can help you spot data entry errors that you may have otherwise missed.

Step 1

Select the cells that you wish to search for duplicates.

Step 2

Click on the "Home" tab within the Ribbon.

Step 3

Click "Conditional Formatting" within the "Styles" section.

Step 4

Click "Highlight Cell Rules." Select "Duplicate Values" from the cascading menu.

Step 5

Select "Duplicate" from the drop-down menu located on the left side the "Duplicate Values" dialog box. Select the fill color and text color you want Excel to apply to duplicate cells using the drop-down menu on the right side of the dialog box.

Step 6

Click "OK" to close the dialog box. Duplicate values within the selected cells should now appear in the fill color and text color you selected.