ConditionalFormat API in JavaScript (ES5) Spreadsheet API control

Represents the Conditional Formatting.

Properties

cFColor

CFColor

Specifies Conditional formatting Highlight Color.

Defaults to ‘RedFT’

format

FormatModel

Specifies format.

Defaults to {}

range

string

Specifies Conditional formatting range.

Defaults to ”

type

HighlightCell | TopBottom | DataBar | ColorScale | IconSet

Specifies Conditional formatting Type.

Defaults to ‘GreaterThan’

value

string

Specifies Conditional formatting Value.

Defaults to ”