Chapter 6: Conditional formatting with formulas
Exercise 29: Delete an unwanted rule
Task
A rule left by a previous owner fills the whole table blue. Delete only the blue rule.
Moves 0 (target 1)8 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 | Account | YoY change | |
| 2 | Sales | 1200 | |
| 3 | Cost | -300 | |
| 4 | Expenses | -150 | |
| 5 | Profit | 750 | |
| 6 | |||
| 7 |
A rule left by a previous owner fills the whole table blue. Delete only the blue rule.
This drill is for computer screens. On a phone you can review the steps.
- Select A2:B5
- Home > Conditional Formatting > Manage Rules (Alt → H → L → R)
- Select the blue rule, click Delete Rule, then OK
Key takeaway
Clear Rules removes everything. To remove just one, use Manage Rules.
See conditional formatting for details.