## ConditionalFormattingCollection class

Encapsulates a collection of FormatCondition objects.

## Methods

| Name | Description |
| --- | --- |
| [add()](#add) | Adds a FormatConditions to the collection. |
| [add()](#add-1) | Reserved for internal use. |
| [clear()](#clear) |  |
| [contains()](#contains) | Reserved for internal use. |
| [copy(cfs)](#copy) | Copies conditional formatting. |
| [get(index)](#get) | Gets the FormatConditions element at the specified index. |
| [get()](#get-1) | Reserved for internal use. |
| [getCount()](#getcount) |  |
| [indexOf()](#indexof) | Reserved for internal use. |
| [iterator()](#iterator) |  |
| [removeArea(startRow, startColumn, totalRows, totalColumns)](#removearea) | Remove all conditional formatting in the range. |
| [removeAt()](#removeat) |  |

### add() {#add}

Adds a FormatConditions to the collection.

**Returns:** Number — `Number` FormatConditions object index.

### add() {#add-1}

Reserved for internal use.

### clear() {#clear}

### contains() {#contains}

Reserved for internal use.

### copy(cfs) {#copy}

Copies conditional formatting.

| Parameter | Type | Description |
| --- | --- | --- |
| cfs | ConditionalFormattingCollection | The conditional formatting |

### get(index) {#get}

Gets the FormatConditions element at the specified index.

| Parameter | Type | Description |
| --- | --- | --- |
| index | Number | The zero based index of the element. |

### get() {#get-1}

Reserved for internal use.

### getCount() {#getcount}

### indexOf() {#indexof}

Reserved for internal use.

### iterator() {#iterator}

### removeArea(startRow, startColumn, totalRows, totalColumns) {#removearea}

Remove all conditional formatting in the range.

| Parameter | Type | Description |
| --- | --- | --- |
| startRow | Number | The start row of the range. |
| startColumn | Number | The start column of the range. |
| totalRows | Number | The number of rows of the range. |
| totalColumns | Number | The number of columns of the range. |

### removeAt() {#removeat}