A newer version of this page is available. Switch to the current version.

TopBottomRuleFormatCondition Class

Represents the Top-Bottom and Average conditional formats.

Namespace: DevExpress.Xpf.Grid

Assembly: DevExpress.Xpf.Grid.v19.1.Core.dll


public class TopBottomRuleFormatCondition :
Public Class TopBottomRuleFormatCondition
    Inherits ExpressionConditionBase


This conditional format allows you to highlight top/bottom values or values that are above/below an average value.

The image below shows a grid column whose top 20 Profit values are green.


To create this conditional format in code, create the TopBottomRuleFormatCondition class instance and specify the following settings:

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

   <dxg:TopBottomRuleFormatCondition Rule="TopItems" Threshold="20" FieldName="Profit" PredefinedFormatName="GreenFillWithDarkGreenText" />

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

var profitFormatCondition = new TopBottomRuleFormatCondition() {
   Rule = TopBottomRule.TopItems,
   Threshold = 20,    
   FieldName = "Profit", 
   PredefinedFormatName = "GreenFillWithDarkGreenText"
See Also