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