# GrapeCity.Spreadsheet.FormatConditionType

## Content

<div class="doc-site-dotnet-api-container">




  <h1 id="GrapeCity_Spreadsheet_FormatConditionType" data-uid="GrapeCity.Spreadsheet.FormatConditionType" class="text-break">FormatConditionType Enum
</h1>
  <div class="markdown level0 summary"><p>Specifies whether the conditional format is based on a cell value or an expression.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Spreadsheet.html">GrapeCity.Spreadsheet</a></h6>
  <h6><strong>Assembly</strong>: GrapeCity.Spreadsheet.dll</h6>
  <h5 id="GrapeCity_Spreadsheet_FormatConditionType_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public enum FormatConditionType</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Enum FormatConditionType</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="GrapeCity_Spreadsheet_FormatConditionType_AboveAverageCondition">AboveAverageCondition</td>
        <td><p>This conditional formatting rule highlights cells that are above or below the average for all values in the range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_BlanksCondition">BlanksCondition</td>
        <td><p>This conditional formatting rule highlights cells that are completely blank.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_CellValue">CellValue</td>
        <td><p>This conditional formatting rule highlights cells base on cell value.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_ColorScale">ColorScale</td>
        <td><p>This conditional formatting rule creates a gradated color scale on the cells.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_Custom">Custom</td>
        <td><p>This is a customized conditional formatting rule.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_Databar">Databar</td>
        <td><p>This conditional formatting rule displays a gradated data bar in the range of cells.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_ErrorsCondition">ErrorsCondition</td>
        <td><p>This conditional formatting rule highlights cells with formula errors.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_Expression">Expression</td>
        <td><p>This conditional formatting rule contains a formula to evaluate.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_IconSet">IconSet</td>
        <td><p>This conditional formatting rule applies icons to cells according to their values.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_NoBlanksCondition">NoBlanksCondition</td>
        <td><p>This conditional formatting rule highlights cells that are not blank.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_NoErrorsCondition">NoErrorsCondition</td>
        <td><p>This conditional formatting rule highlights cells without formula errors.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_TextString">TextString</td>
        <td><p>This conditional formatting rule highlights cells base on cell text.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_TimePeriod">TimePeriod</td>
        <td><p>This conditional formatting rule highlights cells containing dates in the specified time period.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_Top10">Top10</td>
        <td><p>This conditional formatting rule highlights cells whose values fall in the top N or bottom N bracket, as specified.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_FormatConditionType_UniqueValues">UniqueValues</td>
        <td><p>This conditional formatting rule highlights cells that contain unique value or duplicated values in the range.</p>
</td>
      </tr>
    </tbody>
  </table>
</div>