Excel.Interfaces.PresetCriteriaConditionalFormatLoadOptions interface

Package:

excel

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).

TypeScript

$all?: boolean;

Property Value

boolean

format

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

TypeScript

format?: Excel.Interfaces.ConditionalRangeFormatLoadOptions;

Property Value

Excel.Interfaces.ConditionalRangeFormatLoadOptions

Remarks

[ API set: ExcelApi 1.6 ]

rule

The rule of the conditional format.

TypeScript

rule?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]