How to: Apply Conditional Formatting to Grid Cells using the Date Occurring Format Condition
- 2 minutes to read
The Date Occurring format condition (FormatConditionDateOccurring) allows you to apply formatting to date-time values of a specific date and/or date interval relative to today.
This example demonstrates how to apply conditional formatting to Grid cells whose values fall into one of the predefined intervals.
using DevExpress.DashboardCommon;
using DevExpress.XtraEditors;
namespace Grid_DateOccurring {
public partial class Form1 : DevExpress.XtraEditors.XtraForm {
public Form1() {
InitializeComponent();
dashboardViewer1.DataSourceOptions.ObjectDataSourceLoadingBehavior = DevExpress.DataAccess.DocumentLoadingBehavior.LoadAsIs;
Dashboard dashboard = new Dashboard();
dashboard.LoadFromXml(@"..\..\Data\Dashboard.xml");
dashboardViewer1.Dashboard = dashboard;
GridDashboardItem grid = (GridDashboardItem)dashboard.Items["gridDashboardItem1"];
GridDimensionColumn date = (GridDimensionColumn)grid.Columns[0];
GridItemFormatRule dateOccurringRule = new GridItemFormatRule(date);
FormatConditionDateOccurring dateOccurringCondition = new FormatConditionDateOccurring();
dateOccurringCondition.DateType = FilterDateType.MonthAgo1 | FilterDateType.MonthAgo2;
dateOccurringCondition.StyleSettings =
new AppearanceSettings(FormatConditionAppearanceType.PaleOrange);
dateOccurringRule.Condition = dateOccurringCondition;
dateOccurringRule.ApplyToRow = true;
grid.FormatRules.Add(dateOccurringRule);
}
}
}
See Also