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

VerticalGridFormatConditionTopBottom Class

A grid format condition that allows you to highlight top or bottom cell values.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v18.2.dll


public class VerticalGridFormatConditionTopBottom :
Public Class VerticalGridFormatConditionTopBottom
    Inherits GridFormatConditionTopBottom


ASPxVerticalGrid supports conditional formatting, i.e., automatically applies cell formatting based on the specified rules. The ASPxVerticalGrid.FormatConditions property provides access to a collection of rules which are represented by the GridFormatConditionBase class descendants.

Use the VerticalGridFormatConditionTopBottom object to create a format condition allowing you to highlight top or bottom cell values. The conditional formatting is determined for the row specified by the GridFormatConditionBase.FieldName property. By default, the formatting is applied to the same row. The style format, which can be specified by the GridFormatConditionExpressionBase.Format property, is applied to a cell (or record, provided the VerticalGridFormatConditionTopBottom.ApplyToRecord property is set to true) whose value meets the condition specified by the GridFormatConditionTopBottom.Rule property.

When the GridFormatConditionTopBottom.Rule property is set to the BottomItems, BottomPercent, TopItems, or TopPercent values, use the GridFormatConditionTopBottom.Threshold property to specify additional condition information, i.e., the number of items or the percent. The AboveAverage and BelowAverage values do not require additional parameters.

If the GridFormatConditionExpressionBase.Format property is set to Custom, the formatting style can be specified by the VerticalGridFormatConditionTopBottom.CellStyle.

Online Demo

Conditional Formatting

See Also