IconCriterion Object Members

  • Article
Excel Developer Reference

Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule.

Properties

  Name Description
Bb242306.properties(en-us,office.12).gif Index Returns a Long value indicating which threshold the criteria represents. Read-only.
Bb242306.properties(en-us,office.12).gif Operator Returns or sets one of the constants of the XlFormatConditionOperator enumeration which specifes if the threshold is "greater than" or "greater than or equal" to the threshold value.
Bb242306.properties(en-us,office.12).gif Type Returns one of the constants of the XlConditionValueTypes enumeration, which specifies how the threshold value for an icon set is determined. Read-only.
Bb242306.properties(en-us,office.12).gif Value Returns or sets the threshold value for an icon in a conditional format. Read/write Variant.