ColorScale.AppliesTo (Excel)
Returns a Range object specifying the cell range to which the formatting rule is applied.
Dim rngAppliesTo As Range
Set rngAppliesTo = ActiveCell.FormatConditions(1).AppliesTo
Returns a Range object specifying the cell range to which the formatting rule is applied.
Dim rngAppliesTo As Range
Set rngAppliesTo = ActiveCell.FormatConditions(1).AppliesTo