Change Theme Settings
Change Theme Settings
Themes
 
Show All Themes
v
...v

Conditional Formatting

Customer Name 
Freight Descending
Unit Price 
Discount 
Quantity 
Total 
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)Prev1234567…214215216Next

The DevExpress ASP.NET Grid View (ASPxGridView) 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 at design time or 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 grid 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 a grid export capabilities in the Export with Format Conditions demo.

Collapse/Expand
Local Copy of this Demo
To inspect the source code for this demo on your machine, you must first install our components via the DevExpress Component Installer.
You can open a local copy of this online demo directly from this webpage (if using v20.2.8, 21.1.4 or higher).
Open CS Solution
Open VB Solution
The source code files for this demo are installed (by default) in the following directories:
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\CS\ASPxGridViewDemos
\Users\Public\Documents\DevExpress Demos XX.X\Components\ASP.NET\VB\ASPxGridViewDemos

Your Next Great ASP.NET App Starts Here

Get started today and download your 30-day trial of ASP.NET Controls and Libraries (includes 30 days of free technical support).
All demos ship with full source code and are included in the DevExpress ASP.NET distribution. Refer to the Demos and Sample Applications topic to learn more.

DevExpress ASP.NET Controls and Libraries ship as part of DevExpress Universal, DXperience and ASP.NET Subscriptions and are backed by a 60 day unconditional money-back guarantee.
To learn more and obtain pricing information, visit the Compare Features and Pricing webpage. For immediate assistance, contact us by Email at info@devexpress.com or by phone at +1 (818) 844-3383 between 7:30am and 4:30pm Pacific Time.