Chapter 6: Conditional formatting with formulas
Exercise 28: Change rule priority
Task
100 and above should be red and 50 and above yellow, but 100+ is also yellow. Fix the rule order.
Moves 0 (target 1)2 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 | Count | |
| 2 | Smith | 120 | |
| 3 | Johnson | 60 | |
| 4 | Williams | 35 | |
| 5 | Brown | 105 | |
| 6 | Jones | 80 | |
| 7 | |||
| 8 |
100 and above should be red and 50 and above yellow, but 100+ is also yellow. Fix the rule order.
This drill is for computer screens. On a phone you can review the steps.
- Select B2:B6
- Home > Conditional Formatting > Manage Rules (Alt → H → L → R)
- Select the "greater than 99" rule, move it up with ▲, and click OK
Key takeaway
Rules higher in the list apply first. When ranges overlap, put the stricter condition on top.
See conditional formatting for details.