Microsoft Office Tutorials and References
In Depth Information
Formatting PivotTables
Excel extends the capabilities of your PivotTables by enabling you to apply a conditional
format to the PivotTable cells. What’s more, you can select whether to apply the conditional
format to every cell in the Values area, to every cell at the same level as the selected cell
(that is, a regular data cell, a subtotal cell, or a grand total cell) or to every cell that contains
or draws its values from the selected cell’s field (such as the Volume field in the previous
example).
To apply a conditional format to a PivotTable field, click a cell in the Values area. On the
Home tab, in the Styles group, click Conditional Formatting, and then create the desired
conditional format. After you do, Excel displays a Formatting Options action button, which
offers three options for applying the conditional format:
Selected Cells Applies the conditional format to the selected cells only
All Cells Showing Sum of field_name Values Applies the conditional format to
every cell in the data area, regardless of whether the cell is in the data area, a subtotal
row or column, or a grand total row or column
All Cells Showing Sum of field_name Values for Fields Applies the conditional
format to every cell at the same level (for example, data cell, subtotal, or grand total)
as the selected cells
Search JabSto ::




Custom Search