ConditionalFormattingCollection.Remove(CellRange) Method
Removes all conditional formatting rules applied to the specified range of cells.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Parameters
Name | Type | Description |
---|---|---|
range | CellRange | A CellRange object that specifies a range of cells over which the conditional formatting rules are applied. |
Remarks
To remove the ConditionalFormatting object at the specified index from the collection, use the ConditionalFormattingCollection.RemoveAt 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