ConditionalFormatting.Range Property

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

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

Range Range { get; set; }

VB.NET

Property Range As Range

Property Value

Type	Description
Range	A Range 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 Range.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.