# GrapeCity.Spreadsheet.IFormatConditions

## Content

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



  <h1 id="GrapeCity_Spreadsheet_IFormatConditions" data-uid="GrapeCity.Spreadsheet.IFormatConditions" class="text-break">IFormatConditions Interface
</h1>
  <div class="markdown level0 summary"><p>Represents the collection of conditional formats for a single range.</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_IFormatConditions_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IFormatConditions</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IFormatConditions</code></pre>
  </div>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_Count" data-uid="GrapeCity.Spreadsheet.IFormatConditions.Count">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.Count.html#GrapeCity_Spreadsheet_IFormatConditions_Count">Count</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the number of format conditions.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_Item_System_Int32_" data-uid="GrapeCity.Spreadsheet.IFormatConditions.Item(System.Int32)">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.Item.html#GrapeCity_Spreadsheet_IFormatConditions_Item_System_Int32_">this[int]</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the <a class="xref" href="GrapeCity.Spreadsheet.IFormatCondition.html">IFormatCondition</a> object at the specified index.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_Add_GrapeCity_Spreadsheet_ContainsOperator_System_String_" data-uid="GrapeCity.Spreadsheet.IFormatConditions.Add(GrapeCity.Spreadsheet.ContainsOperator,System.String)">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.Add.html#GrapeCity_Spreadsheet_IFormatConditions_Add_GrapeCity_Spreadsheet_ContainsOperator_System_String_">Add(ContainsOperator, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Adds a new conditional format.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_Add_GrapeCity_Spreadsheet_FormatConditionType_GrapeCity_Spreadsheet_FormatConditionOperator_System_String_System_String_GrapeCity_Spreadsheet_ContainsOperator_GrapeCity_Spreadsheet_TimePeriods_" data-uid="GrapeCity.Spreadsheet.IFormatConditions.Add(GrapeCity.Spreadsheet.FormatConditionType,GrapeCity.Spreadsheet.FormatConditionOperator,System.String,System.String,GrapeCity.Spreadsheet.ContainsOperator,GrapeCity.Spreadsheet.TimePeriods)">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.Add.html#GrapeCity_Spreadsheet_IFormatConditions_Add_GrapeCity_Spreadsheet_FormatConditionType_GrapeCity_Spreadsheet_FormatConditionOperator_System_String_System_String_GrapeCity_Spreadsheet_ContainsOperator_GrapeCity_Spreadsheet_TimePeriods_">Add(FormatConditionType, FormatConditionOperator, string, string, ContainsOperator, TimePeriods)</a>
        </td>
        <td class="markdown level1 summary"><p>Adds a new conditional format.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_Add_GrapeCity_Spreadsheet_TimePeriods_" data-uid="GrapeCity.Spreadsheet.IFormatConditions.Add(GrapeCity.Spreadsheet.TimePeriods)">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.Add.html#GrapeCity_Spreadsheet_IFormatConditions_Add_GrapeCity_Spreadsheet_TimePeriods_">Add(TimePeriods)</a>
        </td>
        <td class="markdown level1 summary"><p>Adds a new conditional format.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_AddAboveAverage" data-uid="GrapeCity.Spreadsheet.IFormatConditions.AddAboveAverage">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.AddAboveAverage.html#GrapeCity_Spreadsheet_IFormatConditions_AddAboveAverage">AddAboveAverage()</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a new <a class="xref" href="GrapeCity.Spreadsheet.IAboveAverage.html">IAboveAverage</a> object representing a conditional formatting rule for the specified range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_AddColorScale_System_Int32_" data-uid="GrapeCity.Spreadsheet.IFormatConditions.AddColorScale(System.Int32)">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.AddColorScale.html#GrapeCity_Spreadsheet_IFormatConditions_AddColorScale_System_Int32_">AddColorScale(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a new <a class="xref" href="GrapeCity.Spreadsheet.IColorScale.html">IColorScale</a> object representing a conditional formatting rule that uses gradations in cell colors to indicate relative differences in the values of cells included in a selected range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_AddDatabar" data-uid="GrapeCity.Spreadsheet.IFormatConditions.AddDatabar">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.AddDatabar.html#GrapeCity_Spreadsheet_IFormatConditions_AddDatabar">AddDatabar()</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a Databar object representing a data bar conditional formatting rule for the specified range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_AddIconSetCondition" data-uid="GrapeCity.Spreadsheet.IFormatConditions.AddIconSetCondition">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.AddIconSetCondition.html#GrapeCity_Spreadsheet_IFormatConditions_AddIconSetCondition">AddIconSetCondition()</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a new <a class="xref" href="GrapeCity.Spreadsheet.IIconSetCondition.html">IIconSetCondition</a> object which represents an icon set conditional formatting rule for the specified range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_AddTop10" data-uid="GrapeCity.Spreadsheet.IFormatConditions.AddTop10">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.AddTop10.html#GrapeCity_Spreadsheet_IFormatConditions_AddTop10">AddTop10()</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a <a class="xref" href="GrapeCity.Spreadsheet.ITop10.html">ITop10</a> object representing a conditional formatting rule for the specified range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_AddUniqueValues" data-uid="GrapeCity.Spreadsheet.IFormatConditions.AddUniqueValues">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.AddUniqueValues.html#GrapeCity_Spreadsheet_IFormatConditions_AddUniqueValues">AddUniqueValues()</a>
        </td>
        <td class="markdown level1 summary"><p>Returns a new <a class="xref" href="GrapeCity.Spreadsheet.IUniqueValues.html">IUniqueValues</a> object representing a conditional formatting rule for the specified range.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Spreadsheet_IFormatConditions_Delete" data-uid="GrapeCity.Spreadsheet.IFormatConditions.Delete">
          <a class="xref" href="GrapeCity.Spreadsheet.IFormatConditions.Delete.html#GrapeCity_Spreadsheet_IFormatConditions_Delete">Delete()</a>
        </td>
        <td class="markdown level1 summary"><p>Deletes all format conditions.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>