How to Highlight Duplicates in Excel 2007

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

Select the cells that you wish to search for duplicates.

Step

Click on the “Home” tab within the Ribbon.

Step

Click “Conditional Formatting” within the “Styles” section.

Step

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

Step

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

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.