GrapeCity.Documents.Excel.IFormatCondition.DateOperator

DateOperator Property

DateOperator

Gets or sets the TimePeriods date operator used in the format condition.

For a time period conditional formatting rule, this value indicates the relative date period used by the rule.

Declaration

TimePeriods DateOperator { get; set; }

Property DateOperator As TimePeriods

Examples

worksheet.Range["A1"].Formula = "=TODAY()-1";
worksheet.Range["B1"].Formula = "=TODAY()";
worksheet.Range["C1"].Formula = "=TODAY()+1";
IFormatCondition condition = (IFormatCondition) worksheet.Range["A1:C1"]
    .FormatConditions.Add(FormatConditionType.TimePeriod, FormatConditionOperator.None, null, null);
condition.Interior.Color = Color.Yellow;
condition.DateOperator = TimePeriods.Today;
TimePeriods dateOperator = condition.DateOperator;