PivotFormatCondition
PivotFormatCondition class
Represents a PivotTable Format Condition in PivotFormatCondition Collection.
Properties
| Name | Type | Description |
|---|---|---|
| ScopeType | Number | Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType |
| RuleType | Number | Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType i |
| FormatConditions | FormatConditionCollection | Get formatconditions for the pivot table condition format . |
Methods
| Name | Description |
|---|---|
| addDataAreaCondition | Adds PivotTable conditional format limit in the data fields. |
| addRowAreaCondition | Adds PivotTable conditional format limit in the row fields. |
| addColumnAreaCondition | Adds PivotTable conditional format limit in the column fields. |
| setConditionalAreas | Sets conditional areas of PivotFormatCondition object. |
PivotFormatCondition.ScopeType property
Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.
Type: Number
PivotFormatCondition.RuleType property
Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.
Type: Number
PivotFormatCondition.FormatConditions property
Get formatconditions for the pivot table condition format .
Type: FormatConditionCollection
addDataAreaCondition(fieldName) (1 of 2)
Adds PivotTable conditional format limit in the data fields.
| Parameter | Type | Description |
|---|---|---|
| fieldName | String | The name of PivotField. |
addDataAreaCondition(dataField) (2 of 2)
Adds PivotTable conditional format limit in the data fields.
| Parameter | Type | Description |
|---|---|---|
| dataField | PivotField | The PivotField in the data fields. |
addRowAreaCondition(fieldName) (1 of 2)
Adds PivotTable conditional format limit in the row fields.
| Parameter | Type | Description |
|---|---|---|
| fieldName | String | The name of PivotField. |
addRowAreaCondition(rowField) (2 of 2)
Adds PivotTable conditional format limit in the row fields.
| Parameter | Type | Description |
|---|---|---|
| rowField | PivotField | The PivotField in the row fields. |
addColumnAreaCondition(fieldName) (1 of 2)
Adds PivotTable conditional format limit in the column fields.
| Parameter | Type | Description |
|---|---|---|
| fieldName | String | The name of PivotField. |
addColumnAreaCondition(columnField) (2 of 2)
Adds PivotTable conditional format limit in the column fields.
| Parameter | Type | Description |
|---|---|---|
| columnField | PivotField | The PivotField in the column fields. |
setConditionalAreas()
Sets conditional areas of PivotFormatCondition object.