Edit

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 LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: 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 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

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 ]