</ iframe > </noscript> <!-- End Google Tag Manager (noscript) --> <div id="BeforeHeaderContent"> </div> <div id="HeaderContent"> <!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_RATING%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end--> <div id="ProjectTitle"><!--DXMETADATA start type="ProjectTitle" -->Excel for WPF and Silverlight<!--DXMETADATA end--></div> <div id="PageTitle"><div id="PageTitleText"><!--DXMETADATA start type="PageItemTitle" -->XLConditionalFormattingType Enumeration<!--DXMETADATA end--></div></div> </div> <div id="AfterHeaderContent"> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=example,filter=""type=inline""" value="<a class=""PageLink"" href=""#ExampleBookmark"" onclick=""javascript:dxOpenSectionById('exampleSectionHeader');"">$$Example$$</a>" --><!--DXMETADATA end --><!--DXMETADATA start type="Literal" value="<a class=""PageLink"" href=""%%itemqualifiedname%%_members%%OutputFileExtension%%"">$$Members$$</a> " condition="content:content=""%%itemtype%%"",operator=""<>"",value=""Enumeration"""--><!--DXMETADATA end--> <!--DXMETADATA start type="Literal" condition="childitems:itemtype=example,filter=""type=inline""" value="<a class=""PageLink"" href=""#ExampleBookmark"" onclick=""javascript:dxOpenSectionById('exampleSectionHeader');"">$$Example$$</a> " --><!--DXMETADATA end --><!-- Spacing --> <span id="ToggleAllSectionsLink" class="FunctionLink"> <label id="CollapseAllLabel"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label> <label id="ExpandAllLabel" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label> </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end --><!-- Spacing --> <span id="LanguageFilterPopupLink" class="PopupLink" data-popupcontentsource="#LanguageCheckboxes" data-popuptitle='<!--DXMETADATA start type="Phrase" name="Language_Filter" -->Language Filter<!--DXMETADATA end -->'> <label id="ShowAllLabel" for="LanguageFilterPopupLink"> <!--DXMETADATA start type="Phrase" name="Language_Filter_All" -->Language Filter: All<!--DXMETADATA end --> </label> <label id="MultipleLabel" for="LanguageFilterPopupLink" style="display: none;"> <!--DXMETADATA start type="Phrase" name="Language_Filter_Multiple" -->Language Filter: Multiple<!--DXMETADATA end --> </label> <label id="VBAllLabel" for="LanguageFilterPopupLink" style="display: none;"> <!--DXMETADATA start type="Phrase" name="Language_Filter" -->Language Filter<!--DXMETADATA end -->: <!--DXMETADATA start type="Phrase" name="Language_VB" -->Visual Basic<!--DXMETADATA end --> </label> <!--DXMETADATA start type="FilteredItemList" scrap="LANGUAGE_LABEL_LIST" namespace="language" filter="type=all" source="Item" format="" --> <label id="VBLabel" for="LanguageFilterPopupLink" style="display: none;">Language Filter: Visual Basic (Declaration)</label> <label id="CSLabel" for="LanguageFilterPopupLink" style="display: none;">Language Filter: C#</label> <!--DXMETADATA end --> </span> <div class="PopupContent" id="LanguageCheckboxes"> <!--DXMETADATA start type="FilteredItemList" scrap="LANGUAGE_CHECKBOX_LIST" namespace="language" filter="type=all" source="Item" format="" --> <input data-languagename="VB" id="VBLanguageCheckbox" type="checkbox" class="ToggleLanguageCheckbox" checked="true" data-toggleclass="FilteredContentVB"> <label class="LanguageFilter" for="VBCheckbox"> Visual Basic (Declaration) </label> <br><input data-languagename="CS" id="CSLanguageCheckbox" type="checkbox" class="ToggleLanguageCheckbox" checked="true" data-toggleclass="FilteredContentCS"> <label class="LanguageFilter" for="CSCheckbox"> C# </label> <!--DXMETADATA end --> </div> <!--DXMETADATA start type="IsWebOutputRootPageLinkEnabled" format="<a href='#' class='PageLink' id='viewInFrameLink' title='$$VIEW_WITH_NAVIGATION_TOOLS_TIP$$' style='display: none' data-root-page='%%WebOutputRootPage%%%%OutputFileExtension%%' target='_top'>$$VIEW_WITH_NAVIGATION_TOOLS_TEXT$$</a>" --><!--DXMETADATA end--> </div> <!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="BreadcrumbsContainer"><table><tr><td> <a href="C1.WPF.Excel.4~C1.WPF.Excel_namespace.html">C1.WPF.Excel Namespace</a> : XLConditionalFormattingType Enumeration</td></tr></table></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="GENERICARGUMENT_BUBBLES" namespace="generic argument" source="Item" --><!--DXMETADATA end --> <div id="BodyContent"> <!--DXMETADATA start type="Description" source="Item" format="<div class=""DescriptionContent"">%%description%%</div>" --><div class="DescriptionContent">Conditional formatting type.</div><!--DXMETADATA end --> <!--DXMETADATA start type="SyntaxSection" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=syntax,caption=$$Syntax$$%%%%SyntaxSection%%</div>" --><div class="SectionHeading" id="syntaxSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Syntax</span></div><div id="syntaxSectionContent" class="SectionContent"> <div class="TabContainer" id="TabContainer"> <ul> <li class="FilteredContentVBAll"><a href="#Syntax-VBAll">Visual Basic</a></li> <li class="FilteredContentCS"><a href="#Syntax-CS">C#</a></li> </ul> <div id="Syntax-VB" class="FilteredContentVB"> <pre><pre><span style="color: #008000; ">'Declaration </span> </pre><pre><span style="color: #0000FF; ">Public</span> <span style="color: #0000FF; ">Enum</span> XLConditionalFormattingType <span style="color: #0000FF; ">Inherits</span> System.Enum</pre></pre> </div> <div id="Syntax-CS" class="FilteredContentCS"> <pre><pre><span style="color: #0000FF; ">public</span> <span style="color: #0000FF; ">enum</span> XLConditionalFormattingType : System.Enum </pre></pre> </div> </div> </div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" condition="content:content=""%%IsEnumValuesEnabled%%"",operator=""<>"",value=""True""" scrap="ENUM_MEMBER_LIST" namespace="enumerationmember" source="Item" filter="" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=enummembers,caption=$$Members$$%%%%filtereditemlist%%</div>" --><div class="SectionHeading" id="enummembersSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Members</span></div><div id="enummembersSectionContent" class="SectionContent"><table class="FilteredItemListTable"><tr><th>Member</th><th>Description</th></tr> <tr><td class="MemberNameCell"><strong>AboveAverage</strong></td><td class="DescriptionCell">Conditional formatting type is above values then average value.</td></tr> <tr><td class="MemberNameCell"><strong>BelowAverage</strong></td><td class="DescriptionCell">Conditional formatting type is below values then average value.</td></tr> <tr><td class="MemberNameCell"><strong>Bottom10</strong></td><td class="DescriptionCell">Conditional formatting type is bottom n (rank) values.</td></tr> <tr><td class="MemberNameCell"><strong>Bottom10Percent</strong></td><td class="DescriptionCell">Conditional formatting type is bottom n (rank) percent values.</td></tr> <tr><td class="MemberNameCell"><strong>CellIs</strong></td><td class="DescriptionCell">Conditional formatting type is cell value.</td></tr> <tr><td class="MemberNameCell"><strong>ContainsText</strong></td><td class="DescriptionCell">Conditional formatting type is contains text.</td></tr> <tr><td class="MemberNameCell"><strong>DuplicateValues</strong></td><td class="DescriptionCell">Conditional formatting type is duplicate values.</td></tr> <tr><td class="MemberNameCell"><strong>EndsWith</strong></td><td class="DescriptionCell">Conditional formatting type is end with.</td></tr> <tr><td class="MemberNameCell"><strong>Expression</strong></td><td class="DescriptionCell">Conditional formatting type is formula.</td></tr> <tr><td class="MemberNameCell"><strong>TimePeriod</strong></td><td class="DescriptionCell">Conditional formatting type is time periods (today, yesterday ...).</td></tr> <tr><td class="MemberNameCell"><strong>Top10</strong></td><td class="DescriptionCell">Conditional formatting type is top n (rank) values.</td></tr> <tr><td class="MemberNameCell"><strong>Top10Percent</strong></td><td class="DescriptionCell">Conditional formatting type is top n (rank) percent values.</td></tr> <tr><td class="MemberNameCell"><strong>Unknown</strong></td><td class="DescriptionCell">Conditional formatting type is unknown.</td></tr> </table></div><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" condition="content:content=""%%IsEnumValuesEnabled%%"",operator=""="",value=""True""" scrap="ENUM_MEMBER_LIST_WITH_VALUE" namespace="enumerationmember" source="Item" filter="" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=enummembers,caption=$$Members$$%%%%filtereditemlist%%</div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="TaggedComment" source="Item" id="##REMARKS,##MODULE_REMARKS" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=remarks,caption=$$Remarks$$%%%%comment%%</div>" --><!--DXMETADATA end --> <a name="exampleBookmark"></a> <!--DXMETADATA start type="TaggedComment" source="Item" id="##EXAMPLEINTRO" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=example,caption=""$$Example$$%%designlist:tagidentifier=##EXAMPLECODE,itemtype=Example%%""%%%%comment%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="EXAMPLEGROUP_LIST" namespace="ExampleGroup" source="Item" filter="type=inline" condition="content:content=""%%GroupExamples%%"",operator=""="",value=""True""" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%taggedcomment:source=item,id=##EXAMPLEINTRO,blankformat=""%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=example,caption=$$Example$$%%"",format= %%%%filtereditemlist%%</div>" blankformat="%%taggedcomment:source=item,id=##EXAMPLEINTRO,format=</div>%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="INLINE_EXAMPLE" namespace="Example" source="Item" filter="type=inline" condition="content:content=""%%GroupExamples%%"",operator=""<>"",value=""True""" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%taggedcomment:source=item,id=##EXAMPLEINTRO,blankformat=""%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=example,caption=$$Example$$%%"",format= %%%%filtereditemlist%%</div>" blankformat="%%taggedcomment:source=item,id=##EXAMPLEINTRO,format=</div>%%" --><!--DXMETADATA end --> <!--DXMETADATA start type="FilteredItemList" scrap="MENU_LINK" namespace="example" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=example,caption=$$Example$$%%%%filtereditemlist%%</div>" --><!--DXMETADATA end --> <!--DXMETADATA start type="InheritanceHierarchy" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=inheritance,caption=$$Inheritance_hierarchy$$%%%%InheritanceHierarchy%%</div>" --><div class="SectionHeading" id="inheritanceSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Inheritance Hierarchy</span></div><div id="inheritanceSectionContent" class="SectionContent"><p>System.Object<br> System.ValueType<br> System.Enum<br> <strong>C1.WPF.Excel.XLConditionalFormattingType</strong><br></p></div><!--DXMETADATA end --> <!--DXMETADATA start type="TaggedComment" source="Item" id="##REQUIREMENTS" format="%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=requirements,caption=$$Requirements$$%%%%comment%%</div>" blankformat="%%variable:name=defaulttyperequirements%%" --><div class="SectionHeading" id="requirementsSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">Requirements</span></div><div id="requirementsSectionContent" class="SectionContent"><p><b>Target Platforms:</b> Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2</p></div><!--DXMETADATA end --> <a name="seealsobookmark"></a> <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORIZED_LINKS" namespace="linkcategory" source="Item" filter="type=nomodulelinks" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""$$See_Also$$%%designlist:tagidentifier=##SEEALSO,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><div class="SectionHeading" id="seealsoSectionHeading"><span class="SectionHeadingIcon"><!-- --></span><span class="SectionHeadingText">See Also</span></div><div id="seealsoSectionContent" class="SectionContent"><h4 class="subHeading">Reference</h4><p><a href="C1.WPF.Excel.4~C1.WPF.Excel_namespace.html">C1.WPF.Excel Namespace</a> </p> </div><!--DXMETADATA end--> </div> <div id="FooterContent"> <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p> </p><p> </p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><!--DXMETADATA end --> <!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end--> </div> </body> </html>