GrapeCity.Documents.Excel.IFormatCondition.AppliesTo

AppliesTo Property

AppliesTo

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

Declaration

IRange AppliesTo { get; set; }

Property AppliesTo As IRange

Examples

worksheet.Range["A1:B5"].Value = new object[,] {{1, 2}, {0, 1}, {0, 0}, {0, 3}, {4, 5}};
IFormatCondition condition = (IFormatCondition) worksheet.Range["B1:B5"]
    .FormatConditions.Add(FormatConditionType.Expression, FormatConditionOperator.None, "=A1", null);
condition.Interior.Color = Color.Yellow;
IRange appliesTo = condition.AppliesTo;