ColorScale

ColorScale class

Describe the ColorScale conditional formatting rule. This conditional formatting rule creates a gradated color scale on the cells.

class ColorScale;

Properties

Property	Type	Description
is3ColorScale	boolean	Indicates whether conditional formatting is 3 color scale.
minCfvo	ConditionalFormattingValue	Readonly. Get or set this ColorScale’s min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.
midCfvo	ConditionalFormattingValue	Readonly. Get or set this ColorScale’s mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or FormatConditionValueType.Min to it.
maxCfvo	ConditionalFormattingValue	Readonly. Get or set this ColorScale’s max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.
minColor	Color	Get or set the gradient color for the minimum value in the range.
midColor	Color	Get or set the gradient color for the middle value in the range.
maxColor	Color	Get or set the gradient color for the maximum value in the range.

is3ColorScale

Indicates whether conditional formatting is 3 color scale.

is3ColorScale : boolean;

minCfvo

Readonly. Get or set this ColorScale’s min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max to it.

minCfvo : ConditionalFormattingValue;

midCfvo

Readonly. Get or set this ColorScale’s mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or FormatConditionValueType.Min to it.

midCfvo : ConditionalFormattingValue;

maxCfvo

Readonly. Get or set this ColorScale’s max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min to it.

maxCfvo : ConditionalFormattingValue;

minColor

Get or set the gradient color for the minimum value in the range.

minColor : Color;

midColor

Get or set the gradient color for the middle value in the range.

midColor : Color;

maxColor

Get or set the gradient color for the maximum value in the range.

maxColor : Color;