Skip to main content
All docs
V25.1
  • Row

    ConditionalFormattingCollection.GetConditionalFormattings(CellRange) Method

    Obtains conditional formatting rules applied to the specified cell range.

    Namespace: DevExpress.Spreadsheet

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

    NuGet Package: DevExpress.Spreadsheet.Core

    Declaration

    IEnumerable<ConditionalFormatting> GetConditionalFormattings(
        CellRange range
    )

    Parameters

    Name Type Description
    range CellRange

    A cell range for which conditional formatting rules are obtained.

    Returns

    Type Description
    IEnumerable<ConditionalFormatting>

    A collection of conditional formats applied to the cell range.

    Remarks

    Use the GetConditionalFormattings method to obtain a collection of conditional formats applied to a specific cell range. This method returns an empty list in the following cases:

    • If the method’s range parameter is null.

    • If the specified range doesn’t contain any conditional formats applied.

    If a cell range specified by the range parameter doesn’t belong to the worksheet that owns the current ConditionalFormattingCollection collection, an ArgumentException occurs.

    See Also