GrapeCity.Documents.Excel.IIconSetCondition.AppliesTo

AppliesTo Property

AppliesTo

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

Use the AppliesTo property to change the range associated with this icon set conditional formatting rule.

Declaration

IRange AppliesTo { get; set; }

Property AppliesTo As IRange

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{10}, {30}, {50}, {70}, {90}};
IIconSetCondition condition = worksheet.Range["A1:A5"].FormatConditions.AddIconSetCondition();
condition.AppliesTo = worksheet.Range["B1:B5"];
IRange appliesTo = condition.AppliesTo;