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

Declaration

public class TopBottomRuleFormatCondition :
    ExpressionConditionBase
Public Class TopBottomRuleFormatCondition
    Inherits ExpressionConditionBase

Remarks

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.

CFTopBottomExample

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:TableView.FormatConditions>
   <dxg:TopBottomRuleFormatCondition Rule="TopItems" Threshold="20" FieldName="Profit" PredefinedFormatName="GreenFillWithDarkGreenText" />
</dxg:TableView.FormatConditions>

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"
};
view.FormatConditions.Add(profitFormatCondition);
See Also