ExcelScript.ColorScaleConditionalFormat interface

Represents the color scale criteria for conditional formatting.

Methods

getCriteria()	The criteria of the color scale. Midpoint is optional when using a two point color scale.
getThreeColorScale()	If `true`, the color scale will have three points (minimum, midpoint, maximum), otherwise it will have two (minimum, maximum).
setCriteria(criteria)	The criteria of the color scale. Midpoint is optional when using a two point color scale.

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

getCriteria(): ConditionalColorScaleCriteria;

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

getThreeColorScale(): boolean;

boolean

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

setCriteria(criteria: ConditionalColorScaleCriteria): void;

void