{description}
{excerpt}If the comparison is between a cell value and two values, this is the minimum value; otherwise this is is the formula to be evaluated for the condition.
{excerpt}
{signature:C#}
 public System.String Formula1{ get; set; }
{signature}{signature:vb.net}
Public Property Formula1() As String
{signature}
{remarks}
If the value of [Condition.ComparisonType|Condition.ComparisonType] is a comparison between a cell value and a single value \(e.g., [Condition.Comparison.CellValueEqualTo|Condition.Comparison#CellValueEqualTo]\), [Formula1|Condition.Formula1] sets or returns a formula whose result will be compared with each cell value in the set of conditionally formatted cells. 

If {{Condition.ComparisonType}} is a comparison between a cell value and two values \(e.g., [Condition.Comparison.CellValueBetween|Condition.Comparison#CellValueBetween]\), {{Formula1}} sets or returns a formula whose result will be the minimum comparison value. 

If the value of {{Condition.ComparisonType}} is [Condition.Comparison.FormulaEvaluation|Condition.Comparison#FormulaEvaluation], {{Formula1}} sets or returns a formula that evaluates to {{true}} or {{false}}.
{remarks}
{example}{code:csharp|title=C#}

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Create();
          ConditionalFormat condFmt = wb.CreateConditionalFormat();
          Condition cond =
               condFmt.CreateCondition(
               Condition.Comparison.CellValueGreaterThan,
               "=100");
          cond.Formula1 = "=99";
        {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.CellValueGreaterThan, _
               "=100")
          cond.Formula1 = "=99"
        {code}

{example}