Excel.Interfaces.PresetCriteriaConditionalFormatLoadOptions interface

Represents the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror.

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 formats font, fill, borders, and other properties.

rule

The rule of the 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 formats font, fill, borders, and other properties.

format?: Excel.Interfaces.ConditionalRangeFormatLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.6 ]

rule

The rule of the conditional format.

rule?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]