Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
Here you want to evaluate the relationship between total revenue and dollars per hour. The idea is
that some strategically applied conditional formatting helps identify opportunities for improvement.
Follow these steps:
1. Place your cursor in the Sales_Amount column.
2. Click the Home tab and select Conditional Formatting.
3. Select New Rule.
The New Formatting Rule dialog box appears, as shown in Figure 15-14.
Figure 15-14: The New Formatting Rule dialog box.
The objective in this dialog box is to identify the cells where the conditional formatting will be
applied, specify the rule type to use, and define the details of the conditional formatting.
1. Identify the cells where your conditional formatting will be applied.
You have three choices:
Selected Cells: This selection applies conditional formatting to only the selected cells.
All cells showing Sales_Amount values: This selection applies conditional formatting to all
values in the Sales_Amount column, including all subtotals and grand totals. This selection
is ideal for use in analyses in which you’re using averages, percentages, or other
calculations where a single conditional formatting rule makes sense for all levels of analysis.
All cells showing Sales_Amount values for Market: This selection applies conditional
formatting to all values in the Sales_Amount column at the Market level only (excludes
subtotals and grand totals). This selection is ideal for use in analyses where you’re using
calculations that make sense only within the context of the level being measured.