Highlight Duplicate Values

Highlight Duplicate Values In Less Than 20 Seconds

In this example I will show you how to highlight duplicate values in a column or row in less than 20 seconds.

Here we have a list of names in Column A which contains some duplicate values.
Highlight Duplicate Values1
The duplicate value are not easily recognisable but if you add some conditional formatting to the column all the duplicate values can easily be seen. To do this…..

Step 1

Highlight the range of cells that contain the data.
Highlight Duplicate Values2

Step 2

In the Home tab select Conditional Formatting >>> HighLight Cells Rules >>> Duplicate Values
Highlight Duplicate Values3

Step 3

Select from the dropdown bar whether you want to highlight Duplicate or Unique values in the range.
If required you can customise the text displayed.
Highlight Duplicate Values4
Click OK.

All duplicate values in the range will now be highlighted.
Highlight Duplicate Values5







Related Articles

Excel Is Fun

Excel Magic Trick 1230

DESCRIPTION Conditional Formatting: Highlight Table with Colour When Name Selected Learn how to create a Logical Formula to colour a table when a name is selected from a drop down: (00:13) Problem Overview (00:35) Keyboard [Read More >>>]

Excel Is Fun

Highline Excel 2016 Class 16

DESCRIPTION In this video learn about Conditional Formatting Topics : (00:16) Introduction (00:43) Built-in Feature: Cell Contains (03:28) Logical Formula: Highlight Row (Record) where cell contains a value. (10:00) Built-in Feature: Below Average (10:55) Logical [Read More >>>]

Excel Is Fun

Excel Magic Trick 1124

DESCRIPTION See how to Conditional Format Weekends & Holidays using the NETWORKDAYS.INTL & NOT functions. Conditionally format serial dates for weekends and holidays. Conditional Formatting. Format Conditionally. Logical Formulas. Format holidays and weekends. WORKBOOKS

Be the first to comment

Leave a Reply