# GrapeCity.Wpf.SpreadSheet.Dialogs.BuiltInDialogs.ConditionalFormatting

## Content

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



<h1 id="GrapeCity_Wpf_SpreadSheet_Dialogs_BuiltInDialogs_ConditionalFormatting_" data-uid="GrapeCity.Wpf.SpreadSheet.Dialogs.BuiltInDialogs.ConditionalFormatting*">ConditionalFormatting Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Wpf_SpreadSheet_Dialogs_BuiltInDialogs_ConditionalFormatting_" data-uid="GrapeCity.Wpf.SpreadSheet.Dialogs.BuiltInDialogs.ConditionalFormatting*"></a>
<h4 id="GrapeCity_Wpf_SpreadSheet_Dialogs_BuiltInDialogs_ConditionalFormatting_GrapeCity_Wpf_SpreadSheet_GcSpreadSheet_System_Boolean_GrapeCity_Spreadsheet_FormatConditionType_GrapeCity_Spreadsheet_FormatConditionOperator_System_Boolean_GrapeCity_Spreadsheet_TopBottom_System_Boolean_System_Int32_System_Int32_" data-uid="GrapeCity.Wpf.SpreadSheet.Dialogs.BuiltInDialogs.ConditionalFormatting(GrapeCity.Wpf.SpreadSheet.GcSpreadSheet,System.Boolean,GrapeCity.Spreadsheet.FormatConditionType,GrapeCity.Spreadsheet.FormatConditionOperator,System.Boolean,GrapeCity.Spreadsheet.TopBottom,System.Boolean,System.Int32,System.Int32)">ConditionalFormatting(GcSpreadSheet, bool, FormatConditionType, FormatConditionOperator, bool, TopBottom, bool, int, int)</h4>
<div class="markdown level1 summary"><p>Gets the conditional formatting dialog that manages all conditional formatting rules in the workbook.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public static IDialog ConditionalFormatting(GcSpreadSheet spread, bool createRule = false, FormatConditionType formatcoditionalType = FormatConditionType.CellValue, FormatConditionOperator cellValueOperator = FormatConditionOperator.Greater, bool isPercent = false, TopBottom topBottom = TopBottom.Top10Top, bool isAbove = true, int selectedRuleCategory = 0, int formatStyleIndex = 0)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Shared Function ConditionalFormatting(spread As GcSpreadSheet, Optional createRule As Boolean = False, Optional formatcoditionalType As FormatConditionType = FormatConditionType.CellValue, Optional cellValueOperator As FormatConditionOperator = FormatConditionOperator.Greater, Optional isPercent As Boolean = False, Optional topBottom As TopBottom = TopBottom.Top10Top, Optional isAbove As Boolean = True, Optional selectedRuleCategory As Integer = 0, Optional formatStyleIndex As Integer = 0) As IDialog</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Wpf.SpreadSheet.GcSpreadSheet.html">GcSpreadSheet</a></td>
      <td><span class="parametername">spread</span></td>
      <td><p>The <a class="xref" href="GrapeCity.Wpf.SpreadSheet.GcSpreadSheet.html">GcSpreadSheet</a> control to work with.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">createRule</span></td>
      <td><p><code>true</code> to show the creating conditional formatting rule dialog.</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="../GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.FormatConditionType.html">FormatConditionType</a></td>
      <td><span class="parametername">formatcoditionalType</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="../GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.FormatConditionOperator.html">FormatConditionOperator</a></td>
      <td><span class="parametername">cellValueOperator</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">isPercent</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="../GrapeCity.Spreadsheet/GrapeCity.Spreadsheet.TopBottom.html">TopBottom</a></td>
      <td><span class="parametername">topBottom</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.boolean">bool</a></td>
      <td><span class="parametername">isAbove</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">selectedRuleCategory</span></td>
      <td></td>
    </tr>
    <tr>
      <td><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.int32">int</a></td>
      <td><span class="parametername">formatStyleIndex</span></td>
      <td></td>
    </tr>
  </tbody>
</table>
<h5 class="returns">Returns</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="GrapeCity.Wpf.SpreadSheet.Dialogs.IDialog.html">IDialog</a></td>
      <td><p>The <a class="xref" href="GrapeCity.Wpf.SpreadSheet.Dialogs.IDialog.html">IDialog</a> object represents the format cells dialog.</p>
</td>
    </tr>
  </tbody>
</table>
</div>