ConditionalFormatting.Range Property

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

Namespace : DevExpress.Spreadsheet

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

• C#
• VB.NET

CellRange Range { get; set; }

Property Range As CellRange

Property Value

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

How to: Apply Conditional Formatting to a Complex Range

ConditionalFormatting Interface

ConditionalFormatting Members

DevExpress.Spreadsheet Namespace