PivotConditionalFormat

PivotConditionalFormat class

Properties

NameTypeDescription
PivotAreasPivotAreaCollection
FormatConditionsFormatConditionCollection
ScopeTypeintThe value of the property is PivotConditionFormatScopeType integer constant.
RuleTypeintThe value of the property is PivotConditionFormatRuleType integer constant.

Methods

NameDescription
getCellAreas
addCellArea
applyTo
addFieldArea

PivotConditionalFormat.PivotAreas property

Type: PivotAreaCollection

PivotConditionalFormat.FormatConditions property

Type: FormatConditionCollection

PivotConditionalFormat.ScopeType property

The value of the property is PivotConditionFormatScopeType integer constant.

Type: int

PivotConditionalFormat.RuleType property

The value of the property is PivotConditionFormatRuleType integer constant.

Type: int

getCellAreas()

addCellArea(ca)

applyTo(row, column, scope)

addFieldArea(axisType, fieldName) (1 of 2)


addFieldArea(axisType, field) (2 of 2)