ConditionalColorScaleCriterion Object (JavaScript API for Excel)

Represents a Color Scale Criterion which contains a type, value and a color.

Properties

Property Type Description Req. Set
color string HTML color code representation of the color scale color. E.g. #FF0000 represents Red. 1.6
formula object A number, a formula, or null (if Type is LowestValue). 1.6
type string What the icon conditional formula should be based on. Possible values are: Invalid, LowestValue, HighestValue, Number, Percent, Formula, Percentile. 1.6

See property access examples.

Relationships

None

Methods

None