Log In
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]HTML Editor
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Expand]Data Shaping
   [Expand]Data Analysis
   [Expand]Data Formatting
     Appearance Customization
     Customizing Appearance of Individual Cells
     ASPxPivotGrid Elements that Support Templates
   [Expand]Data Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Report Server
[Expand]eXpressApp Framework
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Customizing Appearance of Individual Cells

Individual fields have their own styles that can be used to paint the field's header and values. These styles override the styles provided by the Pivot Grid control, and can be accessed via the PivotGridField.HeaderStyle, PivotGridField.CellStyle, PivotGridField.ValueStyle and PivotGridField.ValueTotalStyle properties. If the field's style settings are not specified or not used, it's painted using the style settings provided by the pivot grid.

To customize the appearance of individual cells, handle the ASPxPivotGrid.CustomCellStyle event.

Expanded Example: How to Conditionally Apply Cell Styles

The following example shows how to customize the appearance of specific cells by handling the ASPxPivotGrid.CustomCellStyle event.

In this example, custom style settings (the light yellow background) are applied to data cells whose values are less than 50000.

The image below shows the result:

How would you rate this topic?​​​​​​​