Excel.Interfaces.ColorScaleConditionalFormatLoadOptions interface

Represents an IconSet criteria for conditional formatting.

[ API set: ExcelApi 1.6 ]

Properties

$all
criteria

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

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

[ API set: ExcelApi 1.6 ]

Property Details

$all

$all?: boolean;

Property Value

boolean

criteria

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

[ API set: ExcelApi 1.6 ]

criteria?: boolean;

Property Value

boolean

threeColorScale

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

[ API set: ExcelApi 1.6 ]

threeColorScale?: boolean;

Property Value

boolean