FormatConditionIntersectionLevelMode Type

Lists values used to specify the level on which to apply conditional formatting to pivot cells.

Declaration

export type FormatConditionIntersectionLevelMode = 'Auto' | 'FirstLevel' | 'LastLevel' | 'AllLevels' | 'SpecificLevel'

Members

Name Description
"Auto"

The default level.

"FirstLevel"

First level values are used to apply conditional formatting.

"LastLevel"

The last level values are used to apply conditional formatting.

"AllLevels"

All pivot cells is used to apply conditional formatting.

"SpecificLevel"

Values from the specific level are used to apply conditional formatting.

Remarks

Values listed in this type alias are used to set the PivotItemFormatRule.intersectionLevelMode property.