GrapeCity.Documents.Excel.IUniqueValues.AppliesTo

AppliesTo Property

AppliesTo

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

Use the AppliesTo property to change the range associated with this unique-values or duplicate-values conditional formatting rule.

Declaration

IRange AppliesTo { get; set; }

Property AppliesTo As IRange

Examples

worksheet.Range["A1:A5"].Value = new object[,] {
    {100}, {100}, {200}, {300}, {300}
};
IUniqueValues condition = worksheet.Range["A1:A5"].FormatConditions.AddUniqueValues();
condition.Interior.Color = Color.Yellow;
condition.AppliesTo = worksheet.Range["B1:B5"];
IRange appliesTo = condition.AppliesTo;