[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].NET Core 3 Support
 [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]Filtering and Searching
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus, Navigation, Selection
   [Expand]Drag-and-Drop
   [Collapse]Conditional Formatting
    [Expand]Conditional Formats
    [Collapse]Creating Conditional Formatting Rules
      Conditional Formatting Menu
      Conditional Formatting Rules Manager
     Examples
   [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]Gantt 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]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Conditional Formatting Menu

The Conditional Formatting Menu allows applying conditional formatting rules. The menu is available both at design time and runtime.

Right-click the column to which you want to add a conditional formatting rule and select Conditional Formatting item in the displayed context menu to invoke the conditional formatting menu.

You can enable the conditional formatting menu as follows:

Note

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

The conditional formatting menu allows you to use only predefined formats. Refer to the Specifying Formats section of the Conditional Formats topic to learn more.

Expanded Conditional Formatting Menu Items

The conditional formatting menu consists of the following items:

Highlight Cells Rules

The Highlight Cells Rules submenu allows applying the following conditional formatting rules:

Top/Bottom Rules

The Top/Bottom Rules submenu allows highlighting a specific number of topmost-bottommost values, and values that are above or below an average value.

Data Update Rules

The Data Update Rules submenu allows visualizing changing values in real time.

Data Bars

The Data Bars submenu allows visualizing numeric values using predefined sets of bars.

Color Scales

The Color Scales submenu allows using predefined sets of colors to apply conditional formatting to different ranges of values.

Icon Sets

The Icon Sets submenu allows using predefined sets of icons to apply conditional formatting to different ranges of values.

Clear Rules

If you have already applied rules to columns, the Clear Rules submenu becomes available. This submenu allows deleting rules from a single or all columns.

Manage Rules

The item allows invoking the Conditional Formatting Rules Manager to create new rules and edit applied rules.

Expanded Conditional Formatting Menu Specifics

Call the TableView.ShowFormatConditionDialog (or TreeListView.ShowFormatConditionDialog) method to invoke a conditional format dialog in code.

Use the TableView.FormatConditionDialogServiceTemplate (or TreeListView.FormatConditionDialogServiceTemplate) property to define a custom template for a conditional format dialog.

Expanded See Also

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