'Declaration Public NotInheritable Class IconSetConditionalFormat Inherits ThresholdConditionBase
public sealed class IconSetConditionalFormat : ThresholdConditionBase
This class provides the ability to display an icon inside a cell when that cell's value meets the criteria defined by the relevant IconCriterion.
Each icon set contains between three and five individual icons. The number of icons defines the number of thresholds; for example, a 3-icon set implies 3 thresholds, with each threshold representing approximately 33% of the associated range. A 4-icon set provides 4 thresholds, each representing 25% of the range; a 5-icon set contains 5 thresholds with each representing 20% of the range.
Threshold ranges are pre-defined based on the number of icons in the associated set, although this can be customized using the Value property of the IconCriterion associated with that threshold.
By default thresholds are expressed as percentages; use the Value property to customize this to support a percentile rating or a specific value. How the Value property is interpreted is dependent on the ValueType property.
While the number of thresholds is always fixed at 3, 4, or 5, the icon which is displayed for a given threshold can be customized using the Icon property.
Target Platforms: Windows 8.1, Windows 8.1, Windows 8, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
View on GitHub