Page History

Description

Excerpt
If the value of Condition.ComparisonType is a comparison between a cell value and two values (e.g., Condition.Comparison.CellValueBetween), Formula2 sets or returns a formula whose result will be the maximum comparison value.

Signature

	C#
	C#


 public System.String Formula2{ get; set; }

Signature

	vb.net
	vb.net


Public Property Formula2() As String

Example

Code Block

	csharp
	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 Block

	vb.net
	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"

Space Shortcuts

Page tree

Versions Compared

Old Version 1

New Version Current

Key