Skip to content

Highlight Duplicate Values in Excel

In this article, I will show you how to use conditional formatting to highlight duplicate values in Microsoft Excel.

Example 1

Take the following data.

The goal is to highlight any repeating colors or duplicate values.

To highlight the duplicate values, first select the data.

Next, go to Home Conditional Formatting > Highlight Cell Rules > Duplicate Values.

In the dialog box that appears, make sure to select Duplicate. You can then click Ok.

Excel then highlights all of the duplicate values.

Example 2

Here, you have two lists of names.

The goal is to highlight any names that repeat. Once again, you want to highlight the duplicate values.

Start by selecting the names in the first list. Then hold the CTRL key to select the names in the second list as well.

Next, go to Home Conditional Formatting > Highlight Cell Rules > Duplicate Values.

In the dialog box that appears, make sure to select Duplicate. You can then click Ok.

Excel then highlights all of the values that repeat at least once.

And that is how to highlight duplicate values in Microsoft Excel.

This Post Has One Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top