ConditionalFormattingCollection.Contains(ConditionalFormatting) Method
Indicates whether the collection contains the specified conditional formatting rule.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Parameters
| Name | Type | Description |
|---|---|---|
| formatting | ConditionalFormatting | A ConditionalFormatting object to locate in the collection. |
Returns
| Type | Description |
|---|---|
| Boolean | true, if the collection contains the rule; otherwise, false. |
Remarks
To apply a 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
To remove the conditional formatting rule from the collection, use the ConditionalFormattingCollection.Remove, ConditionalFormattingCollection.RemoveAt or ConditionalFormattingCollection.Clear method.
See Also