[Expand]General Information
[Collapse]WinForms Controls
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Chart Control
  [Expand]Map Control
   [Expand]Product Information
    Product Structure
    Getting Started
   [Expand]Spreadsheet Document
    Supported Formats
   [Expand]Cell Basics
   [Expand]Spreadsheet Formulas
    Defined Names
    Data Binding
    Data Validation
   [Expand]Data Presentation
    Data Grouping
   [Expand]Pivot Table Overview
   [Expand]Charting Overview
   [Expand]Mail Merge Overview
    Find and Replace
   [Collapse]Visual Elements
    [Collapse]Cells and Cell Ranges
      Clipboard Operations
      Cell Formatting
      Conditional Formatting
      Custom Draw
     Rows and Columns
     Name Box
     Pop-Up Menus
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Conditional Formatting

The SpreadsheetControl allows end-users to apply conditional formatting and change the appearance of individual cells based on specific conditions. This feature helps to highlight critical information, or describe trends within cells by using data bars, color scales and built-in icon sets. To enable end-users to apply conditional formatting, add the Styles Ribbon page group to the SpreadsheetControl. See the Getting Started topic for an example on how to provide a Ribbon UI for the SpreadsheetControl.

To programmatically apply conditional formatting, access the ConditionalFormattingCollection collection from the Worksheet.ConditionalFormattings property. Use the methods of this collection to apply different types of conditional formatting rules to a range of cells. For more examples on conditional formatting, refer to the Conditional Formatting section.

Is this topic helpful?​​​​​​​