Excel.Interfaces.ColorScaleConditionalFormatData interface

An interface describing the data returned by calling colorScaleConditionalFormat.toJSON().

Properties

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

criteria

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

criteria?: Excel.ConditionalColorScaleCriteria;

Property Value

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 ]