Message-ID: <1433805937.9013.1711672278503.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9012_1651553516.1711672278503" ------=_Part_9012_1651553516.1711672278503 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Cell.SetConditionalFormat(ConditionalFormat)

Cell.SetConditionalFormat(ConditionalFormat)

Description

=20

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.

=20
C#
=20
 public void SetConditionalFormat(ConditionalFormat conditionalFormat)
=20
=20
vb.net
=20
Public Sub SetConditionalFormat(ByVal conditionalFormat As ConditionalForma=
t)
=20
=20

Paramete= rs

=20
c= onditionalFormat
The=20 ConditionalFormat
to apply to the cell.=20

Examples=20
C#
=20

          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
=20
vb.net
=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

------=_Part_9012_1651553516.1711672278503--