Skip to main content
All docs
V24.2

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

End-User Capabilities: Conditional Formatting

End users can use Conditional Formatting to highlight cells or rows based on a specific condition. Cells and rows can be highlighted using animated data bars, icons, and predefined color scales.

Conditional Formatting

Do the following to apply a format condition to column cells:

  1. Right-click within a column header or data cell to display a context menu.
  2. Click the Conditional Formatting menu item and select a rule.

    Note

    Enable the OptionsMenu.ShowConditionalFormattingItem option to display the Conditional Formatting item within the context menu.

#Create Custom Rules

Click the Manage Rules… menu item to display the manager of conditional formatting rules. The manager allows you to create custom rules.

  1. Click the New Rule… button.
  2. Select the Use a formula to determine which cells to format rule type.
  3. Specify a custom condition.
  4. Click Format to specify appearance settings that should be applied to cells whose values match the condition.
  5. Click OK to save a custom rule.

Create Custom Rules

See Also