Highlight Duplicate Values

Spot repeated entries instantly with a duplicate-values rule.

You will learn to

• Apply a duplicate values rule

How it works

Select a range and choose Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values. Every value that appears more than once is highlighted.