Skip to main content

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

Formatting Above or Below Average Values

  • 2 minutes to read

The Average conditional format allows you to format cells whose values are above or below an average value.

The image below shows the grid column whose Profit cells are red if their values are above average.

CFAverageExample

This topic consists of the following sections:

#Adding Rules in Code

Create the TopBottomRuleFormatCondition class instance and specify the following settings to create a conditional format in code:

The following code sample illustrates how to define a conditional format in markup:

<dxg:TableView.FormatConditions>
   <dxg:TopBottomRuleFormatCondition Rule="AboveAverage" FieldName="Profit" PredefinedFormatName="LightRedFillWithDarkRedText" />
</dxg:TableView.FormatConditions>

The code sample below illustrates how to define the same conditional format in code-behind:

var profitFormatCondition = new TopBottomRuleFormatCondition() {
   Rule = TopBottomRule.AboveAverage,
   FieldName = "Profit", 
   PredefinedFormatName = "LightRedFillWithDarkRedText"
};
view.FormatConditions.Add(profitFormatCondition);

#Adding Rules Using Conditional Formatting Menu

  1. Select the Top/Bottom Rules item in the Conditional Formatting Menu, and choose the required conditional format in the invoked sub menu.
  2. Choose a format to define the applied rule’s visual appearance. The conditional formatting menu allows you to use only predefined formats stored in the TableView.PredefinedFormats (or TreeListView.PredefinedFormats) collection.
  3. Enable the apply format to the entire row option to apply a conditional format to the entire row, if necessary.

CFAverageMenu

#Adding Rules Using Conditional Formatting Rules Manager

  1. Click the New Rule… in the Conditional Formatting Rules Manager.
  2. Select the Format only values that are above or below average rule in the invoked New Formatting Rule dialog.
  3. Choose the conditional format (Above or Below).
  4. To define the visual appearance of the applied rule, click the Format button, and specify the required settings in the invoked Format Cells dialog. See the Format Cells Dialog Window section of the Conditional Formatting Rules Manager topic for more information.

CFAverageManager

See Also