ConditionalFormattingCollection
Contents
[
Hide
]ConditionalFormattingCollection class
Encapsulates a collection of FormatCondition objects.
Methods
| Name | Description |
|---|---|
| add() | Adds a FormatConditions to the collection. |
| add() | Reserved for internal use. |
| clear() | |
| contains() | Reserved for internal use. |
| copy(cfs) | Copies conditional formatting. |
| get(index) | Gets the FormatConditions element at the specified index. |
| get() | Reserved for internal use. |
| getCount() | |
| indexOf() | Reserved for internal use. |
| iterator() | |
| removeArea(startRow, startColumn, totalRows, totalColumns) | Remove all conditional formatting in the range. |
| removeAt() |
add()
Adds a FormatConditions to the collection.
Returns: Number — Number FormatConditions object index.
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
copy(cfs)
Copies conditional formatting.
| Parameter | Type | Description |
|---|---|---|
| cfs | ConditionalFormattingCollection | The conditional formatting |
get(index)
Gets the FormatConditions element at the specified index.
| Parameter | Type | Description |
|---|---|---|
| index | Number | The zero based index of the element. |
get()
Reserved for internal use.
getCount()
indexOf()
Reserved for internal use.
iterator()
removeArea(startRow, startColumn, totalRows, totalColumns)
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. |