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

ConditionalFormat.RemoveCondition(Condition)

Description

=20

Removes the specified Condition f= rom the ConditionalFormat ob= ject.

=20
C#
=20
 public void RemoveCondition(Condition condition)
=20
=20
vb.net
=20
Public Sub RemoveCondition(ByVal condition As Condition)
=20
=20

Paramete= rs

=20
condition=
The=20 Condition object to= remove.=20

Examples=20
C#
=20

          ExcelApplication xla =3D new ExcelApplication();
          Workbook wb =3D xla.Create();
          ConditionalFormat condFmt =3D wb.CreateConditionalFormat();
          Condition cond1 =3D
               condFmt.CreateCondition(
               Condition.Comparison.CellValueBetween,
               "=3D100",
               "=3D150");
          Condition cond2 =3D
               condFmt.CreateCondition(
               Condition.Comparison.CellValueGreaterThan,
               "=3D100");
          condFmt.RemoveCondition(cond2);
        
=20
=20
vb.net
=20

          Dim xla As New ExcelApplication()
          Dim wb As Workbook =3D xla.Create()
          Dim condFmt As ConditionalFormat =3D wb.CreateConditionalFormat()
          Dim cond1 As Condition =3D _
               condFmt.CreateCondition( _
               Condition.Comparison.CellValueGreaterThan, _
               "=3D100")
          Dim cond2 As Condition =3D _
               condFmt.CreateCondition( _
               Condition.Comparison.CellValueBetween, _
               "=3D100", _
               "=3D150")
          condFmt.RemoveCondition(cond2)
        
=20

------=_Part_9782_1477510181.1711702683724--