# C1.Excel.XLConditionalFormattingType

## Content

<div class="doc-site-dotnet-api-container">




  <h1 id="C1_Excel_XLConditionalFormattingType" data-uid="C1.Excel.XLConditionalFormattingType" class="text-break">XLConditionalFormattingType Enum
</h1>
  <div class="markdown level0 summary"><p>Conditional formatting type.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.Excel.html">C1.Excel</a></h6>
  <h6><strong>Assembly</strong>: C1.Excel.dll</h6>
  <h5 id="C1_Excel_XLConditionalFormattingType_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum XLConditionalFormattingType : byte</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum XLConditionalFormattingType As Byte</code></pre>
  </div>
  <h3 id="fields">Fields
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    <thead>
    </thead></thead><tbody>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_AboveAverage">AboveAverage</td>
        <td><p>Conditional formatting type is above values then average value.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_BelowAverage">BelowAverage</td>
        <td><p>Conditional formatting type is below values then average value.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_Bottom10">Bottom10</td>
        <td><p>Conditional formatting type is bottom n (rank) values.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_Bottom10Percent">Bottom10Percent</td>
        <td><p>Conditional formatting type is bottom n (rank) percent values.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_CellIs">CellIs</td>
        <td><p>Conditional formatting type is cell value.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_ContainsText">ContainsText</td>
        <td><p>Conditional formatting type is contains text.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_DuplicateValues">DuplicateValues</td>
        <td><p>Conditional formatting type is duplicate values.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_EndsWith">EndsWith</td>
        <td><p>Conditional formatting type is end with.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_Expression">Expression</td>
        <td><p>Conditional formatting type is formula.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_TimePeriod">TimePeriod</td>
        <td><p>Conditional formatting type is time periods (today, yesterday ...).</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_Top10">Top10</td>
        <td><p>Conditional formatting type is top n (rank) values.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_Top10Percent">Top10Percent</td>
        <td><p>Conditional formatting type is top n (rank) percent values.</p>
</td>
      </tr>
      <tr>
        <td id="C1_Excel_XLConditionalFormattingType_Unknown">Unknown</td>
        <td><p>Conditional formatting type is unknown.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>
