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