Part II: Working with Formulas and Functions
FIGURE 17.12
Configure the New Formatting Rule dialog box to apply the needed formula rule.
- In the list box at the top of the dialog box, click the option called Use a for-
mula to determine which cells to format. This selection evaluates values based on
a formula you specify. If a particular value evaluates to true, then the conditional
formatting is applied to that cell.
- In the formula input box, enter the formula shown here. Note we’re using the
AND function to compare the date in our target cell (E3) to both the start and end
dates found in cells $B$3 and $C$3, respectively. If the target cell falls within the
start and end dates, the formula will evaluate to TRUE, thus triggering the condi-
tional formatting.
=AND(E3>=$B$3,E3<=$C$3)
- Click the Format button and choose your desired formatting. This will open the
Format Cells dialog box, where you’ll have a full set of options for formatting the
font, border, and fill for your target cell.
- Click the OK button once you’ve completed choosing your formatting options.
- Click the OK button twice to confirm your formatting rule back on the New
Formatting Rule dialog box.
