Excel.Interfaces.ColorScaleConditionalFormatData interface

Package:

excel

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

Excel.ConditionalColorScaleCriteria

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 ]