Part II: Working with Formulas and Functions
FIGURE 17.3
The cells in this table are conditionally formatted to show a red background for values falling
below the Prior Year Average value.
To build this basic formatting rule, follow these steps:
- Select the data cells in your target range (cells E3:E14 in this example).
- Click the Home tab of the Excel Ribbon and then select Conditional Formatting
➪ New Rule New Rule. This will open the New Formatting Rule dialog box shown
in Figure 17.4.
FIGURE 17.4
Configure the New Formatting Rule dialog box to apply the needed formula rule.
