IconCriterion Properties (Excel)

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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.

Show: