Highlight the whole row with $
PremiumYou selected A2:C20 and want to highlight the whole row when sales are over 10,000. In D2, write the rule so every cell in the row tests column C. Lock the column with $, but not the row.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Rule | ||
| 2 | Lars | North | 12500 | |||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Premium lesson
Unlock Conditional formatting and every other lesson
This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.
Next with premium:Drop-down lists and data validationCOUNTIF
Need help?
Why this works
Excel writes the rule for the top-left cell of the selection, A2, and moves it to the other cells the way it moves a copied formula.
$C2 locks the column, so A2, B2 and C2 all test C2. The row is not locked, so row 3 tests C3. That is why the whole row is highlighted when sales are over 10,000.
Common mistake: Typing $C$2, so every row tests the same cell and they all change color at once.
The answer
- D2
=$C2>10000