Edytuj

Udostępnij za pośrednictwem


IconCriteria Interface

Definition

Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule.

public interface class IconCriteria : System::Collections::IEnumerable
[System.Runtime.InteropServices.Guid("00024498-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface IconCriteria : System.Collections.IEnumerable
Public Interface IconCriteria
Implements IEnumerable
Attributes
Implements

Examples

The following code example creates a range of numbers representing test scores and then applies an icon set conditional formatting rule to that range. The type of icon set is then changed from the default icons to a five-arrow icon set. Finally, the threshold type is modified from percentile to a hard-coded number.

<span class="label">Sub CreateIconSetCF() 































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































    Dim cfIconSet As IconSetCondition 































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































    'Fill cells with sample data from 1 to 10 































































































































































































































































































































































































































































































































    With ActiveSheet 































































































































































































































































































































































































































































































































        .Range("C1") = 55 































































































































































































































































































































































































































































































































        .Range("C2") = 92 































































































































































































































































































































































































































































































































        .Range("C3") = 88 































































































































































































































































































































































































































































































































        .Range("C4") = 77 































































































































































































































































































































































































































































































































        .Range("C5") = 66 































































































































































































































































































































































































































































































































        .Range("C6") = 93 































































































































































































































































































































































































































































































































        .Range("C7") = 76 































































































































































































































































































































































































































































































































        .Range("C8") = 80 































































































































































































































































































































































































































































































































        .Range("C9") = 79 































































































































































































































































































































































































































































































































        .Range("C10") = 83 































































































































































































































































































































































































































































































































        .Range("C11") = 66 































































































































































































































































































































































































































































































































        .Range("C12") = 74 































































































































































































































































































































































































































































































































    End With 































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































    Range("C1:C12").Select 































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































    'Create an icon set conditional format for the created sample data range 































































































































































































































































































































































































































































































































    Set cfIconSet = Selection.FormatConditions.AddIconSetCondition 































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































    'Change the icon set to a five-arrow icon set 































































































































































































































































































































































































































































































































    cfIconSet.IconSet = ActiveWorkbook.IconSets(xl5Arrows) 































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































    'The IconCriterion collection contains all IconCriteria 































































































































































































































































































































































































































































































































    'By indexing into the collection you can modify each criterion 































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































    With cfIconSet.IconCriteria(2) 































































































































































































































































































































































































































































































































        .Type = xlConditionValueNumber 































































































































































































































































































































































































































































































































        .Value = 60 































































































































































































































































































































































































































































































































        .Operator = 7 































































































































































































































































































































































































































































































































    End With 































































































































































































































































































































































































































































































































    With cfIconSet.IconCriteria(3) 































































































































































































































































































































































































































































































































        .Type = xlConditionValueNumber 































































































































































































































































































































































































































































































































        .Value = 70 































































































































































































































































































































































































































































































































        .Operator = 7 































































































































































































































































































































































































































































































































    End With 































































































































































































































































































































































































































































































































    With cfIconSet.IconCriteria(4) 































































































































































































































































































































































































































































































































        .Type = xlConditionValueNumber 































































































































































































































































































































































































































































































































        .Value = 80 































































































































































































































































































































































































































































































































        .Operator = 7 































































































































































































































































































































































































































































































































    End With 































































































































































































































































































































































































































































































































    With cfIconSet.IconCriteria(5) 































































































































































































































































































































































































































































































































        .Type = xlConditionValueNumber 































































































































































































































































































































































































































































































































        .Value = 90 































































































































































































































































































































































































































































































































        .Operator = 7 































































































































































































































































































































































































































































































































    End With 































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































































End Sub</span>

Remarks

The IconCriteria collection is returned from the IconCriteria property of the IconSetCondition object. You can access each IconCriterion object in the collection by passing an index into the collection. See the example for details.

Properties

_Default[Object]

Reserved for internal use.

Count

Returns a Long value that specifies the number of criteria for an icon set conditional format rule. Read-only.

Item[Object]

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

Methods

GetEnumerator()

Applies to