Message-ID: <327440462.8159.1711634780791.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8158_1907928438.1711634780791" ------=_Part_8158_1907928438.1711634780791 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Resets the current Condition's Comparison type and minimum=
and maximum formulas. The method takes two formulas, and therefore must ta=
ke a Comparison
that requires two formulas, such as C=
omparison.CellValueBetween.
public void ChangeCondition(Comparison comparisonType, System.String formu= la1, System.String formula2)=20
Public Sub ChangeCondition(ByVal comparisonType As Comparison, ByVal formul= a1 As String, ByVal formula2 As String)=20
formula1
and=20
formula2
. The comparison type must require two formulas and ma=
y be set to one of the following values:=20
Comparison.CellValueBetween
or=20
Comparison.CellValueNotBetween.=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); ConditionalFormat condFmt =3D wb.CreateConditionalFormat(); Condition cond =3D condFmt.CreateCondition( Condition.Comparison.CellValueGreaterThan, "=3D100"); cond.ChangeCondition( Condition.Comparison.CellValueBetween, "=3D100", "=3D150");=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim condFmt As ConditionalFormat =3D wb.CreateConditionalFormat() Dim cond As Condition =3D _ condFmt.CreateCondition( _ Condition.Comparison.CellValueGreaterThan, _ "=3D100") cond.ChangeCondition( _ Condition.Comparison.CellValueBetween, _ "=3D100", _ "=3D150")=20