ConditionalFormattingCollection.RemoveAt(Int32) Method

Removes the conditional formatting rule at the specified index from the collection.

Namespace : DevExpress.Spreadsheet

Assembly : DevExpress.Spreadsheet.v25.2.Core.dll

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

void RemoveAt(
    int index
)

Sub RemoveAt(
    index As Integer
)

Parameters

A zero-based integer specifying the index of the rule to be removed. It should be non-negative and less than the number of elements in the collection.

|

Remarks

To remove the specified ConditionalFormatting object, use the ConditionalFormattingCollection.Remove method. To delete all conditional formatting rules from the worksheet, use the ConditionalFormattingCollection.Clear method.

To create the specified conditional formatting rule, use one of the following methods:

• ConditionalFormattingCollection.AddAverageConditionalFormatting
• ConditionalFormattingCollection.AddColorScale2ConditionalFormatting
• ConditionalFormattingCollection.AddColorScale3ConditionalFormatting
• ConditionalFormattingCollection.AddDataBarConditionalFormatting
• ConditionalFormattingCollection.AddExpressionConditionalFormatting
• ConditionalFormattingCollection.AddFormulaExpressionConditionalFormatting
• ConditionalFormattingCollection.AddIconSetConditionalFormatting
• ConditionalFormattingCollection.AddRangeConditionalFormatting
• ConditionalFormattingCollection.AddRankConditionalFormatting
• ConditionalFormattingCollection.AddSpecialConditionalFormatting
• ConditionalFormattingCollection.AddTextConditionalFormatting
• ConditionalFormattingCollection.AddTimePeriodConditionalFormatting

See Also

ConditionalFormattingCollection Interface

ConditionalFormattingCollection Members

DevExpress.Spreadsheet Namespace