# C1.C1Excel.XLConditionalFormattingRule

## Content

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



  <h1 id="C1_C1Excel_XLConditionalFormattingRule" data-uid="C1.C1Excel.XLConditionalFormattingRule" class="text-break">XLConditionalFormattingRule Class
</h1>
  <div class="markdown level0 summary"><p>Conditional formatting.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><span class="xref">XLConditionalFormattingRule</span></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="C1.C1Excel.html">C1.C1Excel</a></h6>
  <h6><strong>Assembly</strong>: C1.C1Excel.4.8.dll</h6>
  <h5 id="C1_C1Excel_XLConditionalFormattingRule_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class XLConditionalFormattingRule</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class XLConditionalFormattingRule</code></pre>
  </div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule__ctor" data-uid="C1.C1Excel.XLConditionalFormattingRule.#ctor">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.-ctor.html#C1_C1Excel_XLConditionalFormattingRule__ctor">XLConditionalFormattingRule()</a>
        </td>
        <td class="markdown level1 summary"><p>Initialization conditional formatting object.</p>
</td>
      </tr>
    </tbody>
  </table>
  <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="C1_C1Excel_XLConditionalFormattingRule_Border" data-uid="C1.C1Excel.XLConditionalFormattingRule.Border">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.Border.html#C1_C1Excel_XLConditionalFormattingRule_Border">Border</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the borders and diagonal of the conditional formatting.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_FirstFormula" data-uid="C1.C1Excel.XLConditionalFormattingRule.FirstFormula">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.FirstFormula.html#C1_C1Excel_XLConditionalFormattingRule_FirstFormula">FirstFormula</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets first formula for this condition.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_Font" data-uid="C1.C1Excel.XLConditionalFormattingRule.Font">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.Font.html#C1_C1Excel_XLConditionalFormattingRule_Font">Font</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the text font and foreground color of the conditional formatting.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_IsEmpty" data-uid="C1.C1Excel.XLConditionalFormattingRule.IsEmpty">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.IsEmpty.html#C1_C1Excel_XLConditionalFormattingRule_IsEmpty">IsEmpty</a>
        </td>
        <td class="markdown level1 summary"><p>Gets is empty flag if not formatting.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_Operator" data-uid="C1.C1Excel.XLConditionalFormattingRule.Operator">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.Operator.html#C1_C1Excel_XLConditionalFormattingRule_Operator">Operator</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets conditional formatting operator (applicable when cell type formating).</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_Parameter" data-uid="C1.C1Excel.XLConditionalFormattingRule.Parameter">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.Parameter.html#C1_C1Excel_XLConditionalFormattingRule_Parameter">Parameter</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets style of parameter object for this condition.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_Pattern" data-uid="C1.C1Excel.XLConditionalFormattingRule.Pattern">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.Pattern.html#C1_C1Excel_XLConditionalFormattingRule_Pattern">Pattern</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the pattern of the conditional formatting.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_Priority" data-uid="C1.C1Excel.XLConditionalFormattingRule.Priority">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.Priority.html#C1_C1Excel_XLConditionalFormattingRule_Priority">Priority</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the priority of the conditional formatting.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_SecondFormula" data-uid="C1.C1Excel.XLConditionalFormattingRule.SecondFormula">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.SecondFormula.html#C1_C1Excel_XLConditionalFormattingRule_SecondFormula">SecondFormula</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets second formula for this condition.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_StopIfTrue" data-uid="C1.C1Excel.XLConditionalFormattingRule.StopIfTrue">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.StopIfTrue.html#C1_C1Excel_XLConditionalFormattingRule_StopIfTrue">StopIfTrue</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the stop if <b>true</b> flag for expressions of the conditional formatting.</p>
</td>
      </tr>
      <tr>
        <td id="C1_C1Excel_XLConditionalFormattingRule_Type" data-uid="C1.C1Excel.XLConditionalFormattingRule.Type">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.Type.html#C1_C1Excel_XLConditionalFormattingRule_Type">Type</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets conditional formatting type.</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="C1_C1Excel_XLConditionalFormattingRule_Clone" data-uid="C1.C1Excel.XLConditionalFormattingRule.Clone">
          <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.Clone.html#C1_C1Excel_XLConditionalFormattingRule_Clone">Clone()</a>
        </td>
        <td class="markdown level1 summary"><p>Creates a new <a class="xref" href="C1.C1Excel.XLConditionalFormattingRule.html">XLConditionalFormattingRule</a> object that is a copy of the current instance.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>