Find Duplicate Data Entries with Conditional Formatting

Finding Duplicates in Excel
© Ted French

The "conditional" part of conditional formatting means that you can control when and where specific formatting changes are applied.

If the data you have selected meets certain conditions, then the formatting change, such as changing the font color or altering the background color of a cell, occurs.

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

To find out how to use this wonderful feature in Excel read the tutorial on how to Find Duplicate Data with Conditional Formatting.

• Remove Duplicate Data Records in Excel
• Excel Conditional Formatting for Dates
• Shading Rows with Conditional Formatting