ExcelScript.ColorScaleConditionalFormat interface

Package:

ExcelScript

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.

Method Details

getCriteria()

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

getCriteria(): ConditionalColorScaleCriteria;

Returns

ExcelScript.ConditionalColorScaleCriteria

getThreeColorScale()

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

getThreeColorScale(): boolean;

Returns

boolean

setCriteria(criteria)

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

setCriteria(criteria: ConditionalColorScaleCriteria): void;

Parameters

criteria

ExcelScript.ConditionalColorScaleCriteria

Returns

void