Excel.Interfaces.TopBottomConditionalFormatLoadOptions interface

Represents a Top/Bottom conditional format.

[ API set: ExcelApi 1.6 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

format

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

[ API set: ExcelApi 1.6 ]

rule

The criteria of the Top/Bottom conditional format.

[ API set: ExcelApi 1.6 ]

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

format

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

[ API set: ExcelApi 1.6 ]

format?: Excel.Interfaces.ConditionalRangeFormatLoadOptions;

Property Value

rule

The criteria of the Top/Bottom conditional format.

[ API set: ExcelApi 1.6 ]

rule?: boolean;

Property Value

boolean