Microsoft Office Tutorials and References
In Depth Information
Chapter 15: Using Pivot Charts
Use a Formula to Determine Which Cells to Format: This selection allows you to specify
your own formula and evaluate each value in the selected range against that formula. If
the values evaluate as true, the conditional formatting is applied. This selection comes in
handy when you’re applying conditions based on the results of an advanced formula or
Data bars, color scales, and icon sets can be used only when the selected cells are formatted
based on their values. This means that if you want to use data bars, color scales, and icon
sets, you must select the Format All Cells Based on Their Values rule type.
In this scenario, you want to identify problem areas using icon sets; therefore, you want to
format the cells based on their values.
3. Define the details of the conditional formatting in the Edit the Rule Description section.
Again, you want to identify problem areas using the slick new icon sets offered by Excel
2013. Select Icon Sets from the Format Style drop-down menu.
4. Select a style appropriate to your analysis.
The style selected in Figure 15-16 is ideal for situations in which your pivot tables cannot
always be viewed in color.
Figure 15-16: Select Icon Sets from the Format Style drop-down menu.
With this configuration, Excel applies the sign icons based on the percentile bands >=67,
>=33, and <33. Keep in mind that the actual percentile bands can be changed based on your
needs. In this scenario, the default percentile bands are sufficient.