Click or drag to resize

ConditionalFormatRuleCollectionAdd2ColorScale Method

Adds a '2-Color Scale' 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: 43.0.35.1049
Syntax
public ColorScaleCondition Add2ColorScale(
	string appliesTo
)

Parameters

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

Return Value

Type: ColorScaleCondition
A ColorScaleCondition set to a newly created conditional formatting rule which can be used to further customize the formatting condition.
Exceptions
ExceptionCondition
ArgumentExceptionParameter 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.

See Also