ConditionalFormattingCollection.Remove(ConditionalFormatting) Method
Removes the specified conditional formatting rule from the collection.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.1.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Parameters
Name | Type | Description |
---|---|---|
formatting | ConditionalFormatting | A ConditionalFormatting object to be removed from the collection. |
Remarks
To delete all conditional formatting rules from the worksheet, use the ConditionalFormattingCollection.Clear method. To remove the ConditionalFormatting object at the specified index from the collection, use the ConditionalFormattingCollection.RemoveAt method.
To apply conditional format to a range of cells, use one of the following methods depending on the rule you wish to create:
- 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