Gets or sets the range of cells to which the conditional formatting rule is applied.
A CellRange object that specifies a cell range to which the conditional formatting rule is applied.
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.