Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

ConditionalFormatting.Range Property

Gets or sets the range of cells to which the conditional formatting rule is applied.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

#Declaration

CellRange Range { get; set; }

#Property Value

Type Description
CellRange

A CellRange object that specifies a cell range to which the conditional formatting rule is applied.

#Remarks

You can apply a conditional formatting rule to a single range of adjacent cells or a complex range combination of multiple non-contiguous ranges. To add a rule to a complex range, create the desired combined range by using the CellRange.Union or IRangeProvider.Union method, and pass it to the required Add*ConditionalFormatting method of the ConditionalFormattingCollection object. For an example, refer to the How to: Apply Conditional Formatting to a Complex Range article.

See Also