Message-ID: <349350608.7637.1711616463336.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7636_1252453386.1711616463336" ------=_Part_7636_1252453386.1711616463336 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Creates a Condition of the speci= fied ComparisonType.=
=20public Condition CreateCondition(Comparison comparisonType, System.String = formula)=20
Public Function CreateCondition(ByVal comparisonType As Comparison, ByVal f= ormula As String) As Condition=20
formula
. The comparison type must require only one formula and=
may be set to one of the following values:=20
Condition.Comparison.FormulaEvaluates,=20
Condition.Comparison.CellValueLessThan,=20
Condition.Comparison.CellValueGreaterThan,=20
Condition.Comparison.CellValueLessThan=
OrEqualTo,=20
Condition.Comparison.CellValueGreat=
erThanOrEqualTo,=20
Condition.Comparison.CellValueEqualTo, or=20
Condition.Comparison.CellValueNotEqualTo.=
=20
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); Range rng =3D wb.Worksheets[0].CreateRange("$B$2:$F$10"= ); ConditionalFormat condFmt =3D wb.CreateConditionalFormat(); Condition cond =3D condFmt.CreateCondition( Condition.Comparison.CellValueGreaterThan, "=3D100"); Font fnt =3D cond.Style.Font; fnt.Bold =3D true; fnt.Color =3D wb.Palette.GetClosestColor(100, 100, 255); rng.SetConditionalFormat(condFmt);=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim rng As Range =3D wb.Worksheets(0).CreateRange("$B$2:$F$1= 0") Dim condFmt As ConditionalFormat =3D wb.CreateConditionalFormat() Dim cond As Condition =3D _ condFmt.CreateCondition( _ Condition.Comparison.CellValueGreaterThan, _ "=3D100") Dim fnt As Font =3D cond.Style.Font fnt.Bold =3D True fnt.Color =3D wb.Palette.GetClosestColor(100, 100, 255) rng.SetConditionalFormat(condFmt)=20