Message-ID: <1797566993.9515.1711692893067.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9514_1882205729.1711692893067" ------=_Part_9514_1882205729.1711692893067 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
Applies the specified Conditi=
onalFormat to the current
Cell.=
If the cell already has a Condi=
tionalFormat, it will be replaced by the specified
Conditio=
nalFormat
.
public void SetConditionalFormat(ConditionalFormat conditionalFormat)=20
Public Sub SetConditionalFormat(ByVal conditionalFormat As ConditionalForma= t)=20
ConditionalFormat
ExcelApplication xla =3D new ExcelApplication(); Workbook wb =3D xla.Create(); Worksheet ws =3D wb.Worksheets[0]; ConditionalFormat condFmt =3D wb.CreateConditionalFormat(); Condition cond =3D condFmt.CreateCondition(Condition.Comparison.C= ellValueGreaterThan, "=3D100"); Font fnt =3D cond.Style.Font; fnt.Bold =3D true; fnt.Color =3D wb.Palette.GetClosestColor(100,100,255); ws.Cells[0,0].SetConditionalFormat(condFmt);=20
Dim xla As New ExcelApplication() Dim wb As Workbook =3D xla.Create() Dim ws As Worksheet =3D wb.Worksheets(0) Dim condFmt As ConditionalFormat =3D wb.CreateConditionalFormat(= ) Dim cond As Condition =3D condFmt.CreateCondition(Condition.Compa= rison.CellValueGreaterThan, "=3D100") Dim fnt As Font =3D cond.Style.Font fnt.Bold =3D True fnt.Color =3D wb.Palette.GetClosestColor(100,100,255) ws.Cells(0,0).SetConditionalFormat(condFmt)=20