IconCriteria.Item Property (Excel)

Returns a single IconCriterion object from the IconCriteria collection. Read-only.

Version Information

Version Added: Excel 2007

Syntax

expression .Item(Index)

expression A variable that represents an IconCriteria object.

Parameters

Name

Required/Optional

Data Type

Description

Index

Required

Variant

The index number of the IconCriterion object.

Remarks

The value of the Index parameter cannot be greater than the number of criteria set for an icon set conditional format. The criteria are equivalent to the threshold values assigned for an icon set. To find the number of threshold values, use the Count property.

See Also

Concepts

IconCriteria Collection

IconCriteria Object Members