Change Theme Settings
Change Theme Settings
Show All Themes

Conditional Formatting

Customer Name 
Freight Descending
Unit Price 
QUICK-Stop1007.6400$12.500 %35$437.50
QUICK-Stop1007.6400$263.500 %30$7,905.00
QUICK-Stop1007.6400$31.230 %40$1,249.20
QUICK-Stop1007.6400$10.000 %60$600.00
Queen Cozinha890.7800$27.8025 %42$875.70
Queen Cozinha890.7800$27.2025 %70$1,428.00
Queen Cozinha890.7800$210.8025 %40$6,324.00
Queen Cozinha890.7800$64.8025 %12$583.20
Save-a-lot Markets830.7500$55.0025 %100$4,125.00
Save-a-lot Markets830.7500$123.7925 %60$5,570.55
Page 1 of 216 (2155 items)Prev1234567214215216Next

The DevExpress ASP.NET MVC GridView supports conditional formatting, i.e., automatically applies cell formatting based on the specified rules. This feature helps end-users to quickly notice critical information, identify trends and exceptions, and compare data.

Formatting rules can be created programmatically. The FormatConditions property provides an access to a collection of rules, which are represented by the GridFormatConditionBase class descendants.

The style settings applied to the cells can be exported together with data to various formats using our data aware export engine. Moreover, when we export data to Excel formats (XLS and XLSX), the format conditions are transformed to corresponding Excel conditional formatting rules. Therefore, you can manage the rules in Excel after export. You can take a look at the GridView export capabilities in the Export with Format Conditions demo.