Add Date Occurring Rule

Spread.Services Documentation
Add Date Occurring Rule
Collapse All Expand All

Spread.Services Documentation > Developer's Guide > Apply Conditional Formatting > Add Date Occurring Rule

The date occurring rule in conditional formatting feature compares the values entered in date format in the cells or a range of cells. This rule can be added using the DateOperator property of the IFormatCondition interface.

Refer to the following example code to add date occurring rule to a range of cells in a worksheet.

C# | Copy Code
--- | ---

    // Adding Date occuring rules
    IFormatCondition condition = worksheet.Range["A1:A4"].FormatConditions.Add(FormatConditionType.TimePeriod) as IFormatCondition;
    condition.DateOperator = TimePeriods.Yesterday;
    condition.Interior.Color = Color.FromRGB(128, 0, 128);

    DateTime now = DateTime.Today;
    worksheet.Range["A1"].Value = now.AddDays(-2);
    worksheet.Range["A2"].Value = now.AddDays(-1);
    worksheet.Range["A3"].Value = now;
    worksheet.Range["A4"].Value = now.AddDays(1);

Copyright © GrapeCity, inc. All rights reserved.