Message-ID: <349350608.7637.1711616463336.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7636_1252453386.1711616463336" ------=_Part_7636_1252453386.1711616463336 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html ConditionalFormat.CreateCondition(Condition.Comparison, String)<= /title> <!--[if gte mso 9]> <xml> <o:OfficeDocumentSettings> <o:TargetScreenSize>1024x640</o:TargetScreenSize> <o:PixelsPerInch>72</o:PixelsPerInch> <o:AllowPNG/> </o:OfficeDocumentSettings> <w:WordDocument> <w:View>Print</w:View> <w:Zoom>90</w:Zoom> <w:DoNotOptimizeForBrowser/> </w:WordDocument> </xml> <![endif]--> <style> <!-- @page Section1 { size: 8.5in 11.0in; margin: 1.0in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; } td { page-break-inside: avoid; } tr { page-break-after: avoid; } div.Section1 { page: Section1; } /* Confluence print stylesheet. Common to all themes for print medi= a */ /* Full of !important until we improve batching for print CSS */ #main { padding-bottom: 1em !important; /* The default padding of 6em is too mu= ch for printouts */ } body { font-family: Arial, Helvetica, FreeSans, sans-serif; font-size: 10pt; line-height: 1.2; } body, #full-height-container, #main, #page, #content, .has-personal-sidebar= #content { background: #fff !important; color: #000 !important; border: 0 !important; width: 100% !important; height: auto !important; min-height: auto !important; margin: 0 !important; padding: 0 !important; display: block !important; } a, a:link, a:visited, a:focus, a:hover, a:active { color: #000; } #content h1, #content h2, #content h3, #content h4, #content h5, #content h6 { font-family: Arial, Helvetica, FreeSans, sans-serif; page-break-after: avoid; } pre { font-family: Monaco, "Courier New", monospace; } #header, .aui-header-inner, #navigation, #sidebar, .sidebar, #personal-info-sidebar, .ia-fixed-sidebar, .page-actions, .navmenu, .ajs-menu-bar, .noprint, .inline-control-link, .inline-control-link a, a.show-labels-editor, .global-comment-actions, .comment-actions, .quick-comment-container, #addcomment { display: none !important; } .comment .date::before { content: none !important; /* remove middot for print view */ } h1.pagetitle img { height: auto; width: auto; } .print-only { display: block; } #footer { position: relative !important; /* CONF-17506 Place the footer at end of= the content */ margin: 0; padding: 0; background: none; clear: both; } #poweredby { border-top: none; background: none; } #poweredby li.print-only { display: list-item; font-style: italic; } #poweredby li.noprint { display:none; } /* no width controls in print */ .wiki-content .table-wrap, .wiki-content p, .panel .codeContent, .panel .codeContent pre, .image-wrap { overflow: visible !important; } /* TODO - should this work? */ #children-section, #comments-section .comment, #comments-section .comment .comment-body, #comments-section .comment .comment-content, #comments-section .comment p { page-break-inside: avoid; } #page-children a { text-decoration: none; } /** hide twixies the specificity here is a hack because print styles are getting loaded before the base styles. */ #comments-section.pageSection .section-header, #comments-section.pageSection .section-title, #children-section.pageSection .section-header, #children-section.pageSection .section-title, .children-show-hide { padding-left: 0; margin-left: 0; } .children-show-hide.icon { display: none; } /* personal sidebar */ .has-personal-sidebar #content { margin-right: 0px; } .has-personal-sidebar #content .pageSection { margin-right: 0px; } --> </style> </head> <body> <h1>ConditionalFormat.CreateCondition(Condition.Comparison, String)</h1= > <div class=3D"Section1"> <h2 id=3D"ConditionalFormat.CreateCondition(Condition.Comparison,St= ring)-Description">Description</h2>=20 <p>Creates a <a href=3D"/display/EW11/Condition">Condition</a> of the speci= fied <a href=3D"/display/EW11/Condition.ComparisonType">ComparisonType</a>.= </p>=20 <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>C#</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"theme: Default; brush: csharp; collapse: false; gutter: false= " style=3D"font-size:12px;"> public Condition CreateCondition(Comparison comparisonType, System.String = formula) </pre>=20 </div> </div>=20 <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>vb.net</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"theme: Default; brush: vbnet; collapse: false; gutter: false"= style=3D"font-size:12px;"> Public Function CreateCondition(ByVal comparisonType As Comparison, ByVal f= ormula As String) As Condition </pre>=20 </div> </div>=20 <h2 id=3D"ConditionalFormat.CreateCondition(Condition.Comparison,String)-Pa= rameters">Parameters</h2>=20 <h6 id=3D"ConditionalFormat.CreateCondition(Condition.Comparison,String)-co= mparisonType">comparisonType</h6> A=20 <a href=3D"/display/EW11/Condition" rel=3D"nofollow">Condition</a> constant= representing the type of comparison Excel will use when comparing a cell v= alue to the result of the parameter=20 <code>formula</code>. The comparison type must require only one formula and= may be set to one of the following values:=20 <a href=3D"/display/EW11/Condition.Comparison#Condition.Comparison-FormulaE= valuates" rel=3D"nofollow">Condition.Comparison.FormulaEvaluates</a>,=20 <a href=3D"/display/EW11/Condition.Comparison#Condition.Comparison-CellValu= eLessThan" rel=3D"nofollow">Condition.Comparison.CellValueLessThan</a>,=20 <a href=3D"/display/EW11/Condition.Comparison#Condition.Comparison-CellValu= eGreaterThan" rel=3D"nofollow">Condition.Comparison.CellValueGreaterThan</a= >,=20 <a href=3D"/display/EW11/Condition.Comparison#Condition.Comparison-CellValu= eLessThanOrEqualTo" rel=3D"nofollow">Condition.Comparison.CellValueLessThan= OrEqualTo</a>,=20 <a href=3D"/display/EW11/Condition.Comparison#Condition.Comparison-CellValu= eGreaterThanOrEqualTo" rel=3D"nofollow">Condition.Comparison.CellValueGreat= erThanOrEqualTo</a>,=20 <a href=3D"/display/EW11/Condition.Comparison#Condition.Comparison-CellValu= eEqualTo" rel=3D"nofollow">Condition.Comparison.CellValueEqualTo</a>, or=20 <a href=3D"/display/EW11/Condition.Comparison#Condition.Comparison-CellValu= eNotEqualTo" rel=3D"nofollow">Condition.Comparison.CellValueNotEqualTo</a>.= =20 <h6 id=3D"ConditionalFormat.CreateCondition(Condition.Comparison,String)-fo= rmula">formula</h6> The result of this formula will be compared to each cel= l value in the set of cells associated with the conditional format.=20 <h2 id=3D"ConditionalFormat.CreateCondition(Condition.Comparison,String)-Re= turns">Returns</h2> A=20 <a href=3D"/display/EW11/Condition" rel=3D"nofollow">Condition</a> object r= epresenting the condition created.=20 <h2 id=3D"ConditionalFormat.CreateCondition(Condition.Comparison,String)-Ex= amples">Examples</h2>=20 <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>C#</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"theme: Default; brush: csharp; gutter: false" style=3D"font-s= ize:12px;"> 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); </pre>=20 </div> </div>=20 <div class=3D"code panel pdl" style=3D"border-width: 1px;"> <div class=3D"codeHeader panelHeader pdl" style=3D"border-bottom-width: 1px= ;"> <b>vb.net</b> </div> <div class=3D"codeContent panelContent pdl">=20 <pre class=3D"theme: Default; brush: csharp; gutter: false" style=3D"font-s= ize:12px;"> 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, 100, 255) rng.SetConditionalFormat(condFmt) </pre>=20 </div> </div> </div> </body> </html> ------=_Part_7636_1252453386.1711616463336--