Conditional Formatting

• Apr 10, 2024
• 2 minutes to read

The GridControl includes a conditional formatting feature, which allows you to change individual cells or rows’ appearance based on specific conditions. This feature helps to highlight critical information, identify trends and exceptions, and compare data.

Run Demo: Conditional Formatting Run Demo: Data Update Animation

The image below demonstrates various types of conditional formatting.

Conditional Formatting uses the Criteria Language Syntax to check if a cell value matches certain criteria. To highlight a row/cell using a Color or Brush stored at the data source level, use techniques from this topic - How to Conditionally Set Background and Foreground for Grid Rows and Cells.

Note

To apply format conditions when you define a custom CellTemplate, the template should contain a BaseEdit class descendant declared as demonstrated in the following topic: Custom In-Place Cell Editors.

Common Features

• Conditional Formats

• Creating Conditional Formatting Rules

• Conditional Formatting Menu

• Conditional Formatting Rules Manager

• Conditional Formatting Filters

Conditional Formats in Details

• 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

• How to: Apply Conditional Formatting
• How to: Apply Conditional Formatting in Code-Behind
• How to: Apply Conditional Formatting Rules Specified in a ViewModel
• How to: Change Background Color for Modified Cells

Usage Notes

• Only Table View and TreeList View that work in Optimized Mode support conditional formatting.
• Conditional formatting does not work with Hierarchical Data Templates.