FormatConditions.AddIconSetCondition method (Excel)
Returns a new IconSetCondition object that represents an icon set conditional formatting rule for the specified range.
Syntax
expression.AddIconSetCondition
expression A variable that represents a FormatConditions object.
Return value
IconSetCondition object
Remarks
Use an icon set to annotate and classify data into three to five categories separated by a threshold value. Each icon represents a range of values. For example, in the 3 Arrows icon set, the red up arrow represents higher values, the yellow sideways arrow represents middle values, and the green down arrow represents lower values.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for