GrapeCity.Documents.Excel.IFormatCondition.Formula2

Formula2 Property

Formula2

Gets or sets the second formula of this conditional format.

This property is used by conditional formatting rules that store two formulas, such as CellValue rules that use the Between or NotBetween operator.

Declaration

object Formula2 { get; set; }

Property Formula2 As Object

Examples

worksheet.Range["A1:A5"].Value = new object[,] {{1}, {3}, {5}, {7}, {9}};
IFormatCondition condition = (IFormatCondition) worksheet.Range["A1:A5"]
    .FormatConditions.Add(FormatConditionType.CellValue, FormatConditionOperator.Between, "2", "8");
condition.Interior.Color = Color.Yellow;
object formula2 = condition.Formula2;