Share via

IconCriterion Members (Excel)

  • Article

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

Icon

Returns or specifies the icon for a criterion in an icon set conditional formatting rule. Read/write

Index

Returns a Long value indicating which threshold the criteria represents. Read-only.

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.

Type

Returns one of the constants of the XlConditionValueTypes enumeration, which specifies how the threshold value for an icon set is determined. Read-only.

Value

Returns or sets the threshold value for an icon in a conditional format. Read/write Variant.