Excel.Interfaces.ColorScaleConditionalFormatLoadOptions interface

  • Reference
Package:
excel

Represents the color scale criteria for conditional formatting.

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

The criteria of the color scale. Midpoint is optional when using a two point color scale.
threeColorScale

If true, the color scale will have three points (minimum, midpoint, maximum), otherwise it will have two (minimum, maximum).

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

criteria

The criteria of the color scale. Midpoint is optional when using a two point color scale.

criteria?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]

threeColorScale

If true, the color scale will have three points (minimum, midpoint, maximum), otherwise it will have two (minimum, maximum).

threeColorScale?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.6 ]