Apply Conditional Formatting to Totals and Sub-totals

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

  1. On your home page, hover over a workbook, click Actions, then select Open.
  2. Click Visualize.
  3. 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

  4. Under Conditional Formatting, use the Apply To option to select <Column Name> Total.
If your visualization has sub-totals 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 in Tables and Pivots.