XlCondFmtTimePeriod Enum

Lists applicable time periods in a “date occurring…” conditional formatting rule.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v18.1.Core.dll

Declaration

C#

public enum XlCondFmtTimePeriod

VB.NET

Public Enum XlCondFmtTimePeriod

Members

Name	Description
Last7Days	A date in the last seven days.
LastMonth	A date occurring last month.
LastWeek	A date occurring last week.
NextMonth	A date occurring next month.
NextWeek	A date occurring next week.
ThisMonth	A date occurring this month.
ThisWeek	A date occurring this week.
Today	Today’s date.
Tomorrow	Tomorrow’s date.
Yesterday	Yesterday’s date.

Related API Members

The following properties accept/return XlCondFmtTimePeriod values:

• XlCondFmtRuleTimePeriod.TimePeriod

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the XlCondFmtTimePeriod enum.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

excel-export-api-examples-t253492/CS/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.cs#L439

XlCondFmtRuleTimePeriod rule = new XlCondFmtRuleTimePeriod();
rule.TimePeriod = XlCondFmtTimePeriod.Yesterday;
// Specify formatting settings to be applied to cells if the condition is true.

VB.NET

excel-export-api-examples-t253492/VB/XLExportExamples/SpreadsheetActions/ConditionalFormattingActions.vb#L438

Dim rule As New XlCondFmtRuleTimePeriod()
rule.TimePeriod = XlCondFmtTimePeriod.Yesterday
' Specify formatting settings to be applied to cells if the condition is true.