Methods

add() → Number

Adds a FormatConditions to the collection.

Returns

Number FormatConditions object index.

add()

Reserved for internal use.

clear()

contains()

Reserved for internal use.

copy(cfs)

Copies conditional formatting.

Parameter

Name Type Optional Description

cfs

ConditionalFormattingCollection

 

The conditional formatting

get(index)

Gets the FormatConditions element at the specified index.

Parameter

Name Type Optional 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.

Parameters

Name Type Optional 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()