Excel + Google Sheets · Below target
Spot who's below target
A rule that colors every row where sales are lower than the target.
The formula
=$B2<$C2What each part means
$B2Sales<$C2Lower than the target
Example
Home → Conditional formatting → New rule → Use a formula
| A | B | C | |
|---|---|---|---|
| 1 | Rep | Sales | Target |
| 2 | Laura | 1,250 | 1,000 |
| 3 | João | 980 | 1,200 |
| 4 | Priya | 2,410 | 2,000 |
| 5 | Tom | 640 | 900 |
| A | B | C | |
|---|---|---|---|
| 1 | Rep | Sales | Target |
| 2 | Laura | 1,250 | 1,000 |
| 3 | João | 980 | 1,200 |
| 4 | Priya | 2,410 | 2,000 |
| 5 | Tom | 640 | 900 |
Step by step
- Select the data, from row 2 down.
- Go to Home → Conditional formatting → New rule → Use a formula.
- Paste the formula:
=$B2<$C2 - Click Format, pick a fill colour and press OK.
In Google Sheets: Format → Conditional formatting → Custom formula is.
Where it works
- Every version of Excel
- Google Sheets
- Excel for the web (free)
The same formula in other languages
- English Below target
- Español Bajo objetivo
- Português Abaixo da meta