Chapter 6: Conditional formatting with formulas
Exercise 25: Color every "Not done" row
Task
Fill each whole row (columns A–C) whose status is "Not done" with light red. Use a formula.
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 | D | |
|---|---|---|---|---|
| 1 | Project | Rep | Status | |
| 2 | Company A | Smith | Done | |
| 3 | Company B | Johnson | Not done | |
| 4 | Company C | Williams | Done | |
| 5 | Company D | Brown | Not done | |
| 6 | Company E | Jones | Done | |
| 7 | ||||
| 8 |
Fill each whole row (columns A–C) whose status is "Not done" with light red. Use a formula.
This drill is for computer screens. On a phone you can review the steps.
- Select A2:C6 (starting from row 2)
- Home > Conditional Formatting > New Rule (Alt → H → L → N)
- Choose "Use a formula to determine which cells to format"
- Enter =$C2="Not done", click Format, choose a light red fill, and click OK
Key takeaway
$C2 locks column C but lets the row change, so every cell in the row checks column C.
See conditional formatting for details.