Excel.Interfaces.TopBottomConditionalFormatLoadOptions interface

Represents a top/bottom conditional format.

Remarks

[ API set: ExcelApi 1.6 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

format

Returns a format object, encapsulating the conditional format's font, fill, borders, and other properties.

rule

The criteria of the top/bottom conditional format.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

format

Returns a format object, encapsulating the conditional format's font, fill, borders, and other properties.

format?: Excel.Interfaces.ConditionalRangeFormatLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.6 ]

rule

The criteria of the top/bottom conditional format.

rule?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]