Highlight Duplicates in Excel

When you want to know what values are common in 2 or more columns, highlighting the duplicate values is the best way to see them visually.

In this article, we will learn how to highlight duplicate values in two or more columns
Highlight Duplicate in Two or More Ranges
Here, I want you to highlight duplicate in ranges A1:A10, C2:C5 and D1:D6. Follow these steps:

  1. To highlight duplicates, select all ranges. To select non adjacent ranges, hold the CTRL key and use mouse to select ranges.
  2. 01

  3. Now go to Home->Conditional Formatting->Highlight Cells Rules->Duplicate Values.
  4. 02
    (Or you can use ALT>H>L>H>D>ENTER sequential shortcut to highlight duplicates)

  5. Hit Enter or Click OK. (before you hit enter, you can see in a small drop down, option is available to highlight duplicates or unique values. And the default formatting option. You may select whatever you like.
  6. You can see each duplicate value highlighted by a color.
    It is damn easy to highlight duplicate values in excel. Isn’t it? But if you have any question regarding this topic or any other, feel free to ask it in comment section below. I love to interact with excel users like you.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube