Message-ID: <1821423931.9625.1711697025217.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9624_127370449.1711697025217" ------=_Part_9624_127370449.1711697025217 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Condition.Style

Condition.Style

Description

Sets or returns the=20 Style that will be set on con= ditionally formatted cells when the current=20 Condition is met.=20
C#
=20
public Style Style{ get; set; }
=20
=20
vb.net
=20
Public Property Style() As Style
=20
=20

Examples

=20
C#
=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
vb.net
=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, 1=
00, 255)
          rng.SetConditionalFormat(condFmt)
        
=20
------=_Part_9624_127370449.1711697025217--