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
Returns the Condition object at = the specified 0-based index.
=20public Condition this[int index] { get; }=20
Public Default ReadOnly Property Item(ByVal index As Integer) As Condition=20
Condition
object.=20
Condition
objects.=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
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