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

ConditionalFormat.Item(Int32)

Description=20

Returns the Condition object at = the specified 0-based index.

=20
C#
=20
 public Condition this[int index] { get; }
=20
=20
vb.net
=20
Public Default ReadOnly Property Item(ByVal index As Integer) As Condition
=20
=20

Parameters

=20
index
The 0-based index= of the=20 Condition object.=20

Remarks

The index det= ermines the order in which conditions will be evaluated. A=20 ConditionalFor= mat may contain up to three=20 Condition objects.=20

Examples

=20
C#
=20

          ExcelApplication xla =3D new ExcelApplication();
          Workbook wb =3D xla.Create();

          //--- Create a range of the cells that will have the conditional =
formatting.
          Range vRange =3D wb.Worksheets[0].CreateRange("$B$2:$F$10&qu=
ot;);
          Area vArea =3D vRange.Areas[0];

          //--- Get the conditional format for the first cell within this r=
ange.
          ConditionalFormat vCndFmt =3D vArea[0,0].ConditionalFormat;

          //--- Modify the first condition.
          Condition vCondition =3D vCondFmt.Condition[0];
          vCondition.ChangeConditionType(Condition.Comparison.CellValueLess=
Than, "=3D100");

          vRange.SetConditionalFormat(vCondFmt);
        
=20
=20
vb.net
=20

          Dim xla As New ExcelApplication()
          Dim wb As Workbook =3D xla.Create()

          '--- Create a range of the cells that will have the conditional f=
ormatting.
          Dim rng As Range =3D wb.Worksheets(0).CreateRange("$B$2:$F$1=
0")
          Dim ar As Area =3D rng.Areas(0)

          '--- Get the conditional format for the first cell within this ra=
nge.
          Dim CondFmt As ConditionalFormat =3D ar(0,0).ConditionalFormat

          '--- Modify the first condition.
          Dim cond As Condition =3D CondFmt.Condition(0)
          cond.ChangeConditionType(Condition.Comparison.CellValueLessThan, =
"=3D100")

          rng.SetConditionalFormat(vCndFmt)
        
=20
------=_Part_10412_420519211.1711724374491--