Chapter 5: Conditional formatting basics
Exercise 22: Highlight duplicate values
Task
Find duplicate employee IDs. Format them with Light Red Fill with Dark Red Text.
Moves 0 (target 1)4 difference(s) from the model
File
Font
Alignment
Number
Styles
Cells
A1Press and release Alt to show KeyTips (Windows). Ctrl + 1 opens Format Cells, Ctrl + Z undoes.
| A | B | C | |
|---|---|---|---|
| 1 | Employee ID | Name | |
| 2 | E-101 | Smith | |
| 3 | E-102 | Johnson | |
| 4 | E-105 | Williams | |
| 5 | E-102 | Brown | |
| 6 | E-108 | Jones | |
| 7 | E-110 | Garcia | |
| 8 | |||
| 9 |
Find duplicate employee IDs. Format them with Light Red Fill with Dark Red Text.
This drill is for computer screens. On a phone you can review the steps.
- Select A2:A7
- Home > Conditional Formatting > Highlight Cells Rules > Duplicate Values (Alt → H → L → H → D)
- Click OK
Key takeaway
Use this to catch typing mistakes in lists and slip numbers.
See conditional formatting for details.