Use Conditional Formatting to Find Duplicate Data in Excel 2007

When you have a lot of data to review in an Excel file it can be tedious finding duplicate values.  Today we will look at how to easily identify duplicate values with Conditional Formatting. 

With the Excel document open highlight the section of the document to search for duplicate entries.

Select_Section

On The Ribbon click under the Home Tab is selected.

home

In the Styles section click on Conditional Formatting \ Highlight Cells Rules \ Duplicate Values.

condition_format

This opens up the Duplicate Values dialog box where you can select how to format the cells with duplicate data.

format

Now you will be able to easily find the cells that contain the duplicate data so you can change the values or delete them.

results

This is a quick and easy tip to help make sure important spreadsheets contain correct information.

Brian Burgess worked in IT for 10 years before pursuing his passion for writing. He's been a tech blogger and journalist for the past seven years, and can be found on his about me page or Google+