GrapeCity.Documents.Excel.IAboveAverage.AppliesTo

AppliesTo Property

AppliesTo

Gets or sets a range object specifying the cell range to which the formatting rule is applied.

Use this property to retrieve the target range of the current above-average conditional formatting rule.

Declaration

IRange AppliesTo { get; set; }

Property AppliesTo As IRange

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {20}, {30}, {40}, {50}};
IAboveAverage format = worksheet.Range["A1:A5"].FormatConditions.AddAboveAverage();
format.Interior.Color = Color.Yellow;
format.AppliesTo = worksheet.Range["B1:B5"];
IRange range = format.AppliesTo;