Version

FormatConditionTimePeriod Enumeration

Constants which define the manner in which a cell's date/time value is compared when evaluating a DateTimeConditionalFormat.
Syntax
'Declaration
 
Public Enum FormatConditionTimePeriod 
   Inherits System.Enum
public enum FormatConditionTimePeriod : System.Enum 
Members
MemberDescription
LastMonthThe cell's date/time value is compared to the month before the current one.
LastSevenDaysThe cell's date/time value meets the condition if it lies within the range of the past seven days, without regard to the System.Globalization.CalendarWeekRule.
LastWeekThe cell's date/time value is compared to the week before the current one, as defined by the System.Globalization.CalendarWeekRule.
NextMonthThe cell's date/time value is compared to the month after the current one.
NextWeekThe cell's date/time value is compared to the week after the current one, as defined by the System.Globalization.CalendarWeekRule.
ThisMonthThe cell's date/time value is compared to the current month.
ThisWeekThe cell's date/time value is compared to the current week, as defined by the System.Globalization.CalendarWeekRule.
TodayThe cell's date/time value is compared to the current date.
TomorrowThe cell's date/time value is compared to the day after the current date.
YesterdayThe cell's date/time value is compared to the day before the current date.
Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also