Page History

{description}
{excerpt}If the value of [Condition.ComparisonType|Condition.ComparisonType] is a comparison between a cell value and two values \(e.g., [Condition.Comparison.CellValueBetween|Condition.Comparison#CellValueBetween]\), [Formula2|Condition.Formula2]
        sets or returns a formula whose result will be the maximum comparison value.{excerpt}
{signature:C#}
 public System.String Formula2{ get; set; }
{signature}{signature:vb.net}
Public Property Formula2() As String
{signature}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          ConditionalFormat condFmt = wb.CreateConditionalFormat();
          Condition cond =
               condFmt.CreateCondition(
               Condition.Comparison.CellValueBetween,
               "=100",
               "=150");
          cond.Formula2 = "=200";
        {code}
{code:vb.net|title=vb.net}

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Create()
          Dim condFmt As ConditionalFormat = wb.CreateConditionalFormat()
          Dim cond As Condition = _
               condFmt.CreateCondition( _
               Condition.Comparison.CellValueBetween, _
               "=100", _
               "=150")
          cond.Formula2 = "=200"
        {code}

{example}