Search results

ConditionalFormatSettings API in JavaScript (ES5) Pivot Table API control

Allows a collection of values fields to change the appearance of the pivot table value cells with different style properties such as background color, font color, font family, and font size based on specific conditions.

Properties

applyGrandTotals

boolean

Allows to apply conditional formatting to the grand totals of row and column axis in the pivot table.

Defaults to true

conditions

Condition

Allows you to choose the operator type such as equals, greater than, less than, etc. for conditional formatting.

label

string

Allows to set the header text of a specific row/column field to apply conditional formatting.

measure

string

Allows to set the value field name to apply conditional formatting.

style

IStyle

Allows to set the custom styles for the formatting applied values in the pivot table.

value1

number

Allows you to set the start value for applying conditional formatting.

value2

number

Allows you to set the end value for applying conditional formatting.

This option will be used by default when the operator Between and NotBetween is chosen to apply.