[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
   Reporting
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Implementation Details
   [Expand]Views
   [Expand]Grid View Data Layout
   [Expand]Binding to Data
   [Expand]Master-Detail Data Representation
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Selection
   [Expand]Filtering and Searching
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus and Navigation
   [Collapse]Conditional Formatting
     Conditional Formats
     Creating Conditional Formatting Rules
     Conditional Formatting Menu
     Conditional Formatting Rules Manager
     Formatting Values Using Comparison Rules
     Formatting Date-Time Values
     Formatting Unique and Duplicate Values
     Formatting Top and Bottom Values
     Formatting Above or Below Average Values
     Formatting Changing Values
     Formatting Values Using Icon Sets
     Formatting Values Using Color Scales
     Formatting Values Using Data Bars
     Formatting Values Using Custom Conditions
     Formatting Focused Cells and Rows
     Examples
   [Expand]Drag-and-Drop
   [Expand]Appearance Customization
   [Expand]MVVM Enhancements
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Miscellaneous
   [Expand]Performance Improvement
   [Expand]Design-Time Features
   [Expand]Visual Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Conditional Formatting Rules Manager

The Conditional Formatting Rules Manager provides the capability to view and edit all conditional formatting rules currently applied to the grid's view, as well as create new ones. The manager is available both at design time and runtime.

Click the Manage Rules item in the Conditional Formatting Menu to invoke the manager.

Set the TableView.AllowConditionalFormattingManager (or TreeListView.AllowConditionalFormattingManager) property to true to enable the manager at runtime.

Note

Specify the type of records contained in the data source using the DataControlBase.DesignTimeDataObjectType property to make the manager correctly work at design time.

This topic consists of the following sections:

Expanded Conditional Formatting Rules Manager Actions

The image below shows the conditional formatting rules manager.

The conditional formatting rules manager provides the following actions:

Element

Action

New Rule... button Opens the New Formatting Rule dialog for creating a new rule.
Edit Rule ... button Opens the Edit Formatting Rule dialog for editing a selected rule. You can double-click a rule to open this dialog.
Delete Rule button Deletes a selected rule.
Up/Down buttons Reorders format rules in the rule list. This allows specifying their priority from high to low.
Apply to the row check box Specifies whether to apply a rule to the entire row.
Column combo box Specifies a field name of a column to which to apply a rule.
Is Enabled check box Specifies whether to enable or disable a rule.
Show formatting rules for combo box Allows filtering rules by a specified grid column.

Expanded Conditional Formatting Rule Types

Use the conditional formatting rules manager to apply the following predefined rule types:

Use the Format Cells dialog to define the applied rule's visual style.

Format all cells based on their values

Allows you to apply conditional formatting rules to cells based on their values. You can use the following format styles:

Format only cells that contain

Allows formatting cells comparing cell values with static values. Rules are based on the following types of cell content:

  • Cell Value - Cells whose values are between (equal to, greater than, less than) the specified value(s).
  • Specific Text - Cells whose values contain (begin/end with) the specified text.
  • Dates Occurring - Date-time values that fall into a specified interval.
  • Blanks - Cells with blank values.

Format only top or bottom ranked values

Allows formatting top or bottom ranked values.

Format only values that are above or below average

Allows formatting values that are above or below average.

Format only unique or duplicate values

Allows formatting values that are unique or duplicate.

Format only changing values

Allows formatting changing values in real time.

Use a formula to determine which cells to format

Allows specifying a custom condition for the rule.

Expanded Format Cells Dialog Window

The Format Cells dialog allows defining the visual appearance of the applied rule. Click the Format button in the New Formatting Rule (or Edit Formatting Rule) dialog to access this window.

Use the Format Cells dialog to specify the following settings:

  • Font - Allows changing cell font attributes.
  • Fill - Allows setting a cell background color.
  • Icon - Allows selecting an icon displayed within the formatted cells.

Expanded Conditional Formatting Rules Manager Specifics

Call the TableView.ShowConditionalFormattingManager (or TreeListView.ShowConditionalFormattingManager) method to invoke the conditional formatting rules manager in code.

Use the TableView.ConditionalFormattingManagerServiceTemplate (or TreeListView.ConditionalFormattingManagerServiceTemplate) property to define a custom template for the conditional formatting rules manager.

Expanded See Also

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