1. SuiteAnalytics
  2. Workbook
  3. Custom Workbooks and Datasets
  4. Creating a Workbook
  5. Conditional Formatting
  6. Conditional Formatting in Pivot Tables

Conditional Formatting in Pivot Tables

In pivot tables, you can highlight measures, subtotals, and grand totals, but only for individual cells, not entire rows.

To apply conditional formatting to a pivot table:

  1. Add the field you want to highlight to the measures section of the Layout panel.

  2. Click the Field Menu icon next to the field in the Layout panel and point to Conditional Formatting.

  3. Click Manage Conditional Formatting.

  4. Select the operators, values, and color or icon for the rule. You can click the add icon Add icon to create multiple rules and apply different colors or icons to the same measure.

  5. Check Apply to subtotals and grand totals if you want to apply your rules to the measure subtotals and grand totals.

  6. Click Apply.

  7. Repeat steps 1-6 for each measure you want to highlight.

Related Topics

General Notices