Explanation

Sometimes you may want to identify duplicates first rather than immediately deleting them.

You can use:

Home → Conditional Formatting → Highlight Cells Rules → Duplicate Values

Example

Duplicate records can be highlighted before making changes.

Why This Is Useful

It helps you:

• Review duplicate data
• Verify whether records are genuinely duplicated
• Avoid deleting valid repeated transactions

Practice

Highlight duplicate Customer names using Conditional Formatting.