Chapter 5: Conditional formatting basics
Exercise 21: Highlight the top 3 sales
Task
Format the top 3 sales with Light Red Fill with Dark Red Text.
Moves 0 (target 1)6 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 | Store | Sales | |
| 2 | Midtown | 4200 | |
| 3 | SoHo | 5100 | |
| 4 | Harlem | 3900 | |
| 5 | Chelsea | 2800 | |
| 6 | Brooklyn | 4800 | |
| 7 | Queens | 6100 | |
| 8 | Bronx | 3100 | |
| 9 | |||
| 10 |
Format the top 3 sales with Light Red Fill with Dark Red Text.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B8
- Home > Conditional Formatting > Top/Bottom Rules > Top 10 Items (Alt → H → L → T → T)
- Change the number to 3 and click OK
Key takeaway
You can change the number in Top 10 Items. Bottom items and above average are also available.
See conditional formatting for details.