ColorScale

ColorScale class

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

Properties

Name	Type	Description
Is3ColorScale	boolean	Indicates whether conditional formatting is 3 color scale.
MinCfvo	ConditionalFormattingValue	Get or set this ColorScale’s min value object. Cannot set null or CFValueObject with type FormatConditionValueType.Max t
MidCfvo	ConditionalFormattingValue	Get or set this ColorScale’s mid value object. Cannot set CFValueObject with type FormatConditionValueType.Max or Format
MaxCfvo	ConditionalFormattingValue	Get or set this ColorScale’s max value object. Cannot set null or CFValueObject with type FormatConditionValueType.Min t
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.

ColorScale.Is3ColorScale property

Indicates whether conditional formatting is 3 color scale.

Type: boolean

ColorScale.MinCfvo property

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

Type: ConditionalFormattingValue

ColorScale.MidCfvo property

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

Type: ConditionalFormattingValue

ColorScale.MaxCfvo property

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

Type: ConditionalFormattingValue

ColorScale.MinColor property

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

Type: Color

ColorScale.MidColor property

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

Type: Color

ColorScale.MaxColor property

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

Type: Color