ConditionalFormattingCollection
Contents
[
Hide
]ConditionalFormattingCollection class
Encapsulates a collection of FormatCondition objects.
Properties
| Name | Type | Description |
|---|---|---|
| Count | int | |
| Item (int) | FormatConditionCollection | Gets the FormatConditions element at the specified index. |
Methods
| Name | Description |
|---|---|
| removeArea | Remove all conditional formatting in the range. |
| copy | Copies conditional formatting. |
| add | Adds a FormatConditions to the collection. |
| clear | |
| removeAt | |
| iterator | |
| get | Reserved for internal use. |
| contains | Reserved for internal use. |
| indexOf | Reserved for internal use. |
ConditionalFormattingCollection.Count property
Type: int
ConditionalFormattingCollection.Item (int) property
Gets the FormatConditions element at the specified index.
Type: FormatConditionCollection
removeArea(startRow, startColumn, totalRows, totalColumns)
Remove all conditional formatting in the range.
| Parameter | Type | Description |
|---|---|---|
| startRow | int | The start row of the range. |
| startColumn | int | The start column of the range. |
| totalRows | int | The number of rows of the range. |
| totalColumns | int | The number of columns of the range. |
copy(cfs)
Copies conditional formatting.
| Parameter | Type | Description |
|---|---|---|
| cfs | ConditionalFormattingCollection | The conditional formatting |
add() (1 of 2)
Adds a FormatConditions to the collection.
Returns: FormatConditions object index.
add(value) (2 of 2)
Reserved for internal use.
clear()
removeAt(index)
iterator()
get(index)
Reserved for internal use.
contains(value)
Reserved for internal use.
indexOf(value)
Reserved for internal use.