excel-vba Conditional formatting using VBA FormatConditions.AddIconSetCondition
Example
Range("a1:a10").FormatConditions.AddIconSetCondition
With Selection.FormatConditions(1)
.ReverseOrder = False
.ShowIconOnly = False
.IconSet = ActiveWorkbook.IconSets(xl3Arrows)
End With
With Selection.FormatConditions(1).IconCriteria(2)
.Type = xlConditionValuePercent
.Value = 33
.Operator = 7
End With
With Selection.FormatConditions(1).IconCriteria(3)
.Type = xlConditionValuePercent
.Value = 67
.Operator = 7
End With
IconSet:
| Name |
|---|
| xl3Arrows |
| xl3ArrowsGray |
| xl3Flags |
| xl3Signs |
| xl3Stars |
| xl3Symbols |
| xl3Symbols2 |
| xl3TrafficLights1 |
| xl3TrafficLights2 |
| xl3Triangles |
| xl4Arrows |
| xl4ArrowsGray |
| xl4CRV |
| xl4RedToBlack |
| xl4TrafficLights |
| xl5Arrows |
| xl5ArrowsGray |
| xl5Boxes |
| xl5CRV |
| xl5Quarters |
Type:
| Name |
|---|
| xlConditionValuePercent |
| xlConditionValueNumber |
| xlConditionValuePercentile |
| xlConditionValueFormula |
Operator:
| Name | Value |
|---|---|
| xlGreater | 5 |
| xlGreaterEqual | 7 |
Value:
Returns or sets the threshold value for an icon in a conditional format.
