71. Highlighting duplicate values

Highlighting Duplicate Values

**Highlighting Duplicate Values** is a common use of conditional formatting in Excel. This feature allows you to visually identify repeated entries in a dataset, making it easier to spot errors or analyze data patterns.

Steps to Highlight Duplicate Values

• Step 1: Select the range of cells to check for duplicates.
• Step 2: Go to the Home tab and click Conditional Formatting.
• Step 3: Choose the rule "Highlight Duplicate Values."
• Step 4: Select a formatting style and click OK.

Interactive Example: Highlight Duplicate Values

#	Value
1	Apple
2	Banana
3	Apple
4	Orange
5	Banana

Click "Highlight Duplicates" to identify and highlight repeated values in the table.