## PivotFormatCondition class

Represents a PivotTable Format Condition in PivotFormatCondition Collection.

## Methods

| Name | Description |
| --- | --- |
| [addColumnAreaCondition(fieldName)](#addcolumnareacondition) | Adds PivotTable conditional format limit in the column fields. |
| [addColumnAreaCondition(columnField)](#addcolumnareacondition-1) | Adds PivotTable conditional format limit in the column fields. |
| [addDataAreaCondition(fieldName)](#adddataareacondition) | Adds PivotTable conditional format limit in the data fields. |
| [addDataAreaCondition(dataField)](#adddataareacondition-1) | Adds PivotTable conditional format limit in the data fields. |
| [addRowAreaCondition(fieldName)](#addrowareacondition) | Adds PivotTable conditional format limit in the row fields. |
| [addRowAreaCondition(rowField)](#addrowareacondition-1) | Adds PivotTable conditional format limit in the row fields. |
| [getFormatConditions()](#getformatconditions) | Get formatconditions for the pivot table condition format . |
| [getRuleType()](#getruletype) | Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType i |
| [getScopeType()](#getscopetype) | Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType |
| [setConditionalAreas()](#setconditionalareas) | Sets conditional areas of PivotFormatCondition object. |
| [setRuleType()](#setruletype) | Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType i |
| [setScopeType()](#setscopetype) | Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType |

### addColumnAreaCondition(fieldName) {#addcolumnareacondition}

Adds PivotTable conditional format limit in the column fields.

| Parameter | Type | Description |
| --- | --- | --- |
| fieldName | String | The name of PivotField. |

### addColumnAreaCondition(columnField) {#addcolumnareacondition-1}

Adds PivotTable conditional format limit in the column fields.

| Parameter | Type | Description |
| --- | --- | --- |
| columnField | PivotField | The PivotField in the column fields. |

### addDataAreaCondition(fieldName) {#adddataareacondition}

Adds PivotTable conditional format limit in the data fields.

| Parameter | Type | Description |
| --- | --- | --- |
| fieldName | String | The name of PivotField. |

### addDataAreaCondition(dataField) {#adddataareacondition-1}

Adds PivotTable conditional format limit in the data fields.

| Parameter | Type | Description |
| --- | --- | --- |
| dataField | PivotField | The PivotField in the data fields. |

### addRowAreaCondition(fieldName) {#addrowareacondition}

Adds PivotTable conditional format limit in the row fields.

| Parameter | Type | Description |
| --- | --- | --- |
| fieldName | String | The name of PivotField. |

### addRowAreaCondition(rowField) {#addrowareacondition-1}

Adds PivotTable conditional format limit in the row fields.

| Parameter | Type | Description |
| --- | --- | --- |
| rowField | PivotField | The PivotField in the row fields. |

### getFormatConditions() {#getformatconditions}

Get formatconditions for the pivot table condition format .

### getRuleType() {#getruletype}

Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.

### getScopeType() {#getscopetype}

Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.

### setConditionalAreas() {#setconditionalareas}

Sets conditional areas of PivotFormatCondition object.

### setRuleType() {#setruletype}

Get and set rule type for the pivot table condition format . The value of the property is PivotConditionFormatRuleType integer constant.

### setScopeType() {#setscopetype}

Get and set scope type for the pivot table condition format . The value of the property is PivotConditionFormatScopeType integer constant.