Apply Conditional Formatting to Totals and Subtotals

In workbooks you can optionally apply conditional formatting rules to totals and subtotals.

Tutorial icon Tutorial

  1. On your home page, hover over a workbook, click Actions, and select Open.
  2. In the Grammar Panel, display the Edge Labels tab, and locate the column where the conditional formatting is applied.
    Description of edge-label.png follows
    Description of the illustration edge-label.png

  3. Under Conditional Formatting, use the Apply To option to select <Column Name> Total.
If your visualization has subtotals or grand totals enabled (on the Totals pane of the Grammar panel) you can also apply conditional formatting to these.
Description of conditional-formatting-totals.png follows
Description of the illustration conditional-formatting-totals.png

See Customize Grand Totals and Subtotals in Tables and Pivots.