Chapter 5: Conditional formatting basics
Exercise 20: Highlight cells below target
Task
Format achievement rates less than 100 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 | Rep | Achievement (%) | |
| 2 | Smith | 85 | |
| 3 | Johnson | 120 | |
| 4 | Williams | 97 | |
| 5 | Brown | 105 | |
| 6 | Jones | 76 | |
| 7 | |||
| 8 |
Format achievement rates less than 100 with Light Red Fill with Dark Red Text.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B6
- Home > Conditional Formatting > Highlight Cells Rules > Less Than (Alt → H → L → H → L)
- Enter 100, keep the default format, and click OK
Key takeaway
When the numbers change, the color updates automatically. Colors filled by hand stay put.
See conditional formatting for details.