A rule is a test
Conditional formatting colors a cell when the rule's formula returns TRUE. In D2, write the rule for "sales over 10,000" as a test of C2, without IF.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Over 10,000? | ||
| 2 | Lars | North | 12500 | |||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
C2>10000 is a test. It returns TRUE for Lars because 12,500 is more than 10,000.
In Excel you type the same formula under Conditional Formatting > New Rule > Use a formula to determine which cells to format. Excel colors the cells where the formula returns TRUE and leaves the rest alone.
Common mistake: Wrapping the test in IF with "Yes" and "No". A rule has to return TRUE or FALSE, not text.
The answer
- D2
=C2>10000
+10 points