ConditionalFormatRuleCollectionAddIconSet Method

Adds an 'Icon Set' conditional formatting rule applied to a specified sequence of references to cell ranges.

Namespace: GemBox.Spreadsheet.ConditionalFormatting
Assembly: GemBox.Spreadsheet (in GemBox.Spreadsheet.dll) Version: 45.0.35.1043

Syntax

Copy

public IconSetCondition AddIconSet(
	string appliesTo
)

Public Function AddIconSet ( 
	appliesTo As String
) As IconSetCondition

Parameters

appliesTo: Type: SystemString
The sequence of references to cell ranges over which the newly added conditional formatting rule is applied.

Return Value

Type: IconSetCondition
An IconSetCondition set to a newly created conditional formatting rule which can be used to further customize the formatting condition.

Exceptions

Exception	Condition
ArgumentException	Parameter appliesTo is or Empty.

Remarks

Newly added rule is inserted at the beginning of the collection so it has the highest priority and is first applied.

Newly added rule has the same default settings as in MS Excel.

Reference

ConditionalFormatRuleCollection Class

GemBox.Spreadsheet.ConditionalFormatting Namespace

Other Resources

Excel Conditional Formatting example

ConditionalFormatRuleCollectionAddLanguageSpecificTextSet("LSTB45F0877_0?cpp=::|nu=.");AddIconSet Method

Parameters

Return Value

Reference

Other Resources

ConditionalFormatRuleCollectionAddIconSet Method