ConditionalFormattingCollection.Contains(ConditionalFormatting) Method

Indicates whether the collection contains the specified conditional formatting rule.

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

bool Contains(
    ConditionalFormatting formatting
)

Function Contains(
    formatting As ConditionalFormatting
) As Boolean

Parameters

A ConditionalFormatting object to locate in the collection.

|

Returns

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

ConditionalFormattingCollection Interface

ConditionalFormattingCollection Members

DevExpress.Spreadsheet Namespace