Conditional Formatting dialog box.
The Conditional Formatting dialog box is big, with enough boxes and buttons to be intimidating, because it's built to take in a lot of possible conditions. But once you know which boxes and buttons to pay attention to, it's a snap (we'll take you through the process step by step in the practice session).
- First you choose the cell value conditions to trigger the conditional formatting by selecting less than and typing 15.
- Then you click the Format button to pick bold red format for any values less than 15.
Now Excel knows that the condition that triggers bold red formatting is any value that is less than 15 in column C. See? It's a snap.
Note You can add up to three conditions to a cell or a given range of cells.