Edit

Share via

IconSetCondition.ReverseOrder property (Excel)

  • Article

Returns or sets a Boolean value indicating if the order of icons is reversed for an icon set.

Syntax

expression.ReverseOrder

expression A variable that represents an IconSetCondition object.

Remarks

By default, most of the icon sets that you can use associate positive images with higher values. For example, the "3 Traffic Lights" icon set applies a green circle to the upper value threshold and a red circle to the lowest values in the range. If your data is such that lower values are more desirable, such as marathon time results, you may want to reverse the order that icons are applied to the range to associate the green circle to the lowest values.

If the IconSet property is xlCustomSet, the ReverseOrder property will return False. Additionally, if you attempt to set the ReverseOrder property to True when the IconSet property is xlCustomSet, Excel will return a run-time error.

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.