Find Duplicates in Excel with Conditional Formatting

Excel's conditional formatting feature is an easy way to add special formatting features to specific areas of your spreadsheets. Depending on the value in a cell, you can change things like the font color of specific data or alter the background color of a cell (or cells).

The “conditional” part of the name means that you can control when and where the formatting changes are applied. If the data meets a certain condition, then the formatting change occurs.

One common use for this feature is to find duplicate data such as duplicate names, dates, or formulas in large tables of data.

To find out just how easy it is to accomplish this in Excel 2007, read the article on Find Duplicates in Excel with Conditional Formatting.

Related Articles

• Excel 2003 Lists- Remove Duplicates (video)
• Excel 2007 Conditional Formatting for Dates
• Excel 2003 Conditional Formatting