.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

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.2.Core.dll

Declaration

CellRange Range { get; set; }
Property Range As CellRange
CellRange Range { get; set; }
Property Range As CellRange
CellRange Range { get; set; }
Property Range As CellRange

Property Value

Type Description
CellRange

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

Property Value

Type Description
CellRange

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

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