IconSetType
IconSetType enumeration
Icon set type for conditional formatting. The threshold values for triggering the different icons within a set are configurable, and the icon order is reversible.
Values
| Name | Value | Description |
|---|---|---|
| Arrows3 | 0 | 3 arrows icon set. |
| ArrowsGray3 | 1 | 3 gray arrows icon set. |
| Flags3 | 2 | 3 flags icon set. |
| Signs3 | 3 | 3 signs icon set. |
| Symbols3 | 4 | 3 symbols icon set (circled). |
| Symbols32 | 5 | 3 Symbols icon set (uncircled). |
| TrafficLights31 | 6 | 3 traffic lights icon set (unrimmed). |
| TrafficLights32 | 7 | 3 traffic lights icon set with thick black border. |
| Arrows4 | 8 | 4 arrows icon set. |
| ArrowsGray4 | 9 | 4 gray arrows icon set. |
| Rating4 | 10 | 4 ratings icon set. |
| RedToBlack4 | 11 | 4 ‘red to black’ icon set. |
| TrafficLights4 | 12 | 4 traffic lights icon set. |
| Arrows5 | 13 | 5 arrows icon set. |
| ArrowsGray5 | 14 | 5 gray arrows icon set. |
| Quarters5 | 15 | 5 quarters icon set. |
| Rating5 | 16 | 5 rating icon set. |
| Stars3 | 17 | 3 stars set |
| Boxes5 | 18 | 5 boxes set |
| Triangles3 | 19 | 3 triangles set |
| None | 20 | None |
| CustomSet | 21 | CustomSet. This element is read-only. |
| Smilies3 | 22 | 3 smilies. Only for .ods. |
| ColorSmilies3 | 23 | 3 color smilies. Only for .ods. |