# FarPoint.Web.Spread.IConditionalFormatSupport

## Content

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



  <h1 id="FarPoint_Web_Spread_IConditionalFormatSupport" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport" class="text-break">IConditionalFormatSupport Interface
</h1>
  <div class="markdown level0 summary"><p>Interface that supports conditional formatting of cells on a sheet.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="FarPoint.Web.Spread.html">FarPoint.Web.Spread</a></h6>
  <h6><strong>Assembly</strong>: FarPoint.Web.Spread.dll</h6>
  <h5 id="FarPoint_Web_Spread_IConditionalFormatSupport_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IConditionalFormatSupport</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IConditionalFormatSupport</code></pre>
  </div>
  <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="FarPoint_Web_Spread_IConditionalFormatSupport_ClearConditionalFormats_System_Int32_System_Int32_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.ClearConditionalFormats(System.Int32,System.Int32)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.ClearConditionalFormats.html#FarPoint_Web_Spread_IConditionalFormatSupport_ClearConditionalFormats_System_Int32_System_Int32_">ClearConditionalFormats(int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Removes all of the conditional formats from the cell at the specified row and column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatInvalidateCell_System_Int32_System_Int32_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatInvalidateCell(System.Int32,System.Int32)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatInvalidateCell.html#FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatInvalidateCell_System_Int32_System_Int32_">ConditionalFormatInvalidateCell(int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Invalidates the conditional format cell that is specified.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatInvalidateColumn_System_Int32_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatInvalidateColumn(System.Int32)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatInvalidateColumn.html#FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatInvalidateColumn_System_Int32_">ConditionalFormatInvalidateColumn(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Invalidates the conditional format cell that is specified.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatInvalidateRow_System_Int32_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatInvalidateRow(System.Int32)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatInvalidateRow.html#FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatInvalidateRow_System_Int32_">ConditionalFormatInvalidateRow(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Invalidates the conditional format cell that is specified.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatIsRowUsed_System_Int32_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatIsRowUsed(System.Int32)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatIsRowUsed.html#FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatIsRowUsed_System_Int32_">ConditionalFormatIsRowUsed(int)</a>
        </td>
        <td class="markdown level1 summary"><p>Determines whether the specified row has a conditional format set.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatNextNonEmptyColumnInRow_System_Int32_System_Int32_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatNextNonEmptyColumnInRow(System.Int32,System.Int32)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.ConditionalFormatNextNonEmptyColumnInRow.html#FarPoint_Web_Spread_IConditionalFormatSupport_ConditionalFormatNextNonEmptyColumnInRow_System_Int32_System_Int32_">ConditionalFormatNextNonEmptyColumnInRow(int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the next non-empty column in the specified row after the specified column
that contains a conditional format.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_GetCellConditionalFormats_System_Int32__System_Int32__System_Boolean_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.GetCellConditionalFormats(System.Int32@,System.Int32@,System.Boolean)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.GetCellConditionalFormats.html#FarPoint_Web_Spread_IConditionalFormatSupport_GetCellConditionalFormats_System_Int32__System_Int32__System_Boolean_">GetCellConditionalFormats(ref int, ref int, bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a conditional format for the next cell after the cell at the specified row and column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_GetColumnConditionalFormats_System_Int32__System_Boolean_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.GetColumnConditionalFormats(System.Int32@,System.Boolean)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.GetColumnConditionalFormats.html#FarPoint_Web_Spread_IConditionalFormatSupport_GetColumnConditionalFormats_System_Int32__System_Boolean_">GetColumnConditionalFormats(ref int, bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a conditional format for the next column after the specified column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_GetConditionalFormats_System_Int32_System_Int32_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.GetConditionalFormats(System.Int32,System.Int32)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.GetConditionalFormats.html#FarPoint_Web_Spread_IConditionalFormatSupport_GetConditionalFormats_System_Int32_System_Int32_">GetConditionalFormats(int, int)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a conditional format from the cell at the specified row and column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_GetConditionalFormats_System_Int32__System_Int32__System_Boolean_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.GetConditionalFormats(System.Int32@,System.Int32@,System.Boolean)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.GetConditionalFormats.html#FarPoint_Web_Spread_IConditionalFormatSupport_GetConditionalFormats_System_Int32__System_Int32__System_Boolean_">GetConditionalFormats(ref int, ref int, bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a conditional format for the next cell after the cell at the specified row and column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_GetRowConditionalFormats_System_Int32__System_Boolean_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.GetRowConditionalFormats(System.Int32@,System.Boolean)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.GetRowConditionalFormats.html#FarPoint_Web_Spread_IConditionalFormatSupport_GetRowConditionalFormats_System_Int32__System_Boolean_">GetRowConditionalFormats(ref int, bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets a conditional format for the next row after the specified row.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_GetValidConditionalFormat_System_Int32_System_Int32_System_Object_FarPoint_Web_Spread_Model_ISheetDataModel_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.GetValidConditionalFormat(System.Int32,System.Int32,System.Object,FarPoint.Web.Spread.Model.ISheetDataModel)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.GetValidConditionalFormat.html#FarPoint_Web_Spread_IConditionalFormatSupport_GetValidConditionalFormat_System_Int32_System_Int32_System_Object_FarPoint_Web_Spread_Model_ISheetDataModel_">GetValidConditionalFormat(int, int, object, ISheetDataModel)</a>
        </td>
        <td class="markdown level1 summary"><p>Gets the style for the first condition that is satisfied
from the list of conditional formats for the cell at the specified row and column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_SetConditionalFormat_System_Int32_System_Int32_FarPoint_Web_Spread_NamedStyle_FarPoint_Web_Spread_ComparisonOperator_FarPoint_CalcEngine_Expression_FarPoint_CalcEngine_Expression_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.SetConditionalFormat(System.Int32,System.Int32,FarPoint.Web.Spread.NamedStyle,FarPoint.Web.Spread.ComparisonOperator,FarPoint.CalcEngine.Expression,FarPoint.CalcEngine.Expression)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.SetConditionalFormat.html#FarPoint_Web_Spread_IConditionalFormatSupport_SetConditionalFormat_System_Int32_System_Int32_FarPoint_Web_Spread_NamedStyle_FarPoint_Web_Spread_ComparisonOperator_FarPoint_CalcEngine_Expression_FarPoint_CalcEngine_Expression_">SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, Expression, Expression)</a>
        </td>
        <td class="markdown level1 summary"><p>Sets a parameterized conditional format for the cell at the specified row and column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_SetConditionalFormat_System_Int32_System_Int32_FarPoint_Web_Spread_NamedStyle_FarPoint_Web_Spread_ComparisonOperator_System_String_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.SetConditionalFormat(System.Int32,System.Int32,FarPoint.Web.Spread.NamedStyle,FarPoint.Web.Spread.ComparisonOperator,System.String)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.SetConditionalFormat.html#FarPoint_Web_Spread_IConditionalFormatSupport_SetConditionalFormat_System_Int32_System_Int32_FarPoint_Web_Spread_NamedStyle_FarPoint_Web_Spread_ComparisonOperator_System_String_">SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Sets a parameterized conditional format for the cell at the specified row and column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_SetConditionalFormat_System_Int32_System_Int32_FarPoint_Web_Spread_NamedStyle_FarPoint_Web_Spread_ComparisonOperator_System_String_System_String_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.SetConditionalFormat(System.Int32,System.Int32,FarPoint.Web.Spread.NamedStyle,FarPoint.Web.Spread.ComparisonOperator,System.String,System.String)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.SetConditionalFormat.html#FarPoint_Web_Spread_IConditionalFormatSupport_SetConditionalFormat_System_Int32_System_Int32_FarPoint_Web_Spread_NamedStyle_FarPoint_Web_Spread_ComparisonOperator_System_String_System_String_">SetConditionalFormat(int, int, NamedStyle, ComparisonOperator, string, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Sets a parameterized conditional format for the cell at the specified row and column.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_IConditionalFormatSupport_SetFormulaConditionalFormat_System_Int32_System_Int32_FarPoint_Web_Spread_NamedStyle_System_String_" data-uid="FarPoint.Web.Spread.IConditionalFormatSupport.SetFormulaConditionalFormat(System.Int32,System.Int32,FarPoint.Web.Spread.NamedStyle,System.String)">
          <a class="xref" href="FarPoint.Web.Spread.IConditionalFormatSupport.SetFormulaConditionalFormat.html#FarPoint_Web_Spread_IConditionalFormatSupport_SetFormulaConditionalFormat_System_Int32_System_Int32_FarPoint_Web_Spread_NamedStyle_System_String_">SetFormulaConditionalFormat(int, int, NamedStyle, string)</a>
        </td>
        <td class="markdown level1 summary"><p>Sets a formula conditional format for the cell at the specified row and column.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>