IconSetCondition.ReverseOrder Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public:
 property bool ReverseOrder { bool get(); void set(bool value); };

public bool ReverseOrder { get; set; }

Public Property ReverseOrder As Boolean

Property Value

Boolean

Boolean

Remarks

By default, most of the icon sets 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.

Applies to