Microsoft Office Tutorials and References
In Depth Information
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