Identifying Duplicates in Excel- Conditional Formatting

Duplicate entries in Excel are often the cause of problems. There are a number of ways to identify which items are duplicates. One of the easiest ways is to use the Conditional Formatting tool which will highlight either all the duplicates or all the unique items. A major benefit is that this is live in that as new data is entered it will automatically change colour if it is a duplicate.

Back to: