GrapeCity.Documents.Excel.IColorScale.AppliesTo

AppliesTo Property

AppliesTo

Gets or sets the IRange object that specifies the cell range to which the formatting rule is applied.

Use the AppliesTo property to change the range associated with this color scale conditional formatting rule.

Declaration

IRange AppliesTo { get; set; }

Property AppliesTo As IRange

Examples

IRange range = worksheet.Range["A1:A5"];
range.Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IColorScale colorScale = range.FormatConditions.AddColorScale(ColorScaleType.TwoColorScale);
IRange appliesTo = colorScale.AppliesTo;