ConditionalIconCriterion Object (JavaScript API for Excel)
Represents an Icon Criterion which contains a type, value, an Operator, and an optional custom icon, if not using an iconset.
Properties
| Property | Type | Description | Req. Set |
|---|---|---|---|
| formula | object | A number or a formula depending on the type. | 1.6 |
| operator | string | GreaterThan or GreaterThanOrEqual for each of the rule type for the Icon conditional format. Possible values are: Invalid, GreaterThan, GreaterThanOrEqual. | 1.6 |
See property access examples.
Relationships
| Relationship | Type | Description | Req. Set |
|---|---|---|---|
| customIcon | Icon | The custom icon for the current criterion if different from the default IconSet, else null will be returned. | 1.6 |
| type | ConditionalFormatIconRuleType | What the icon conditional formula should be based on. | 1.6 |
Methods
None