Skip to main content
Row

IconSetConditionalFormatting Members

Represents an icon set conditional formatting rule.

Properties

Name Description
IconSet Gets or sets an icon set type for conditional formatting.
IsCustom Indicates whether a custom icon set is specified.
Priority Specifies the priority of the conditional formatting rule. Inherited from ConditionalFormatting.
Range Gets or sets the range of cells to which the conditional formatting rule is applied. Inherited from ConditionalFormatting.
Ranges Obsolete. Gets or sets a collection of ranges, to which the conditional format is applied. Inherited from ConditionalFormatting.
Reversed Gets or sets whether icons in the icon set specified in the conditional formatting rule are shown in reverse order.
ShowValue Gets or sets whether to show values of cells to which the icon set conditional formatting rule is applied.
StopIfTrue Specifies whether the rules with lower priority can be applied. Inherited from ConditionalFormatting.
Values Returns an array of threshold values used in the icon set conditional formatting rule.

Methods

Name Description
GetIcon(Int32) Gets an icon by its index from the icon set specified in the icon set conditional format.
SetCustomIcon(Int32, ConditionalFormattingCustomIcon) Inserts a custom icon into the icon set specified in the conditional formatting rule.
See Also