FormatConditionTimePeriod
Constants which define the manner in which a cell's date/time value is compared when evaluating a [[DateTimeConditionalFormat]].
Enumeration Members
Section titled "Enumeration Members"LastMonth
Section titled "LastMonth"The cell's date/time value is compared to the month before the current one.
LastMonth = 9LastSevenDays
Section titled "LastSevenDays"The cell's date/time value meets the condition if it lies within the range of the past seven days, without regard to the [[CalendarWeekRule]].
LastSevenDays = 6LastWeek
Section titled "LastWeek"The cell's date/time value is compared to the week before the current one, as defined by the [[CalendarWeekRule]].
LastWeek = 5NextMonth
Section titled "NextMonth"The cell's date/time value is compared to the month after the current one.
NextMonth = 8NextWeek
Section titled "NextWeek"The cell's date/time value is compared to the week after the current one, as defined by the [[CalendarWeekRule]].
NextWeek = 4ThisMonth
Section titled "ThisMonth"The cell's date/time value is compared to the current month.
ThisMonth = 7ThisWeek
Section titled "ThisWeek"The cell's date/time value is compared to the current week, as defined by the [[CalendarWeekRule]].
ThisWeek = 3Today
Section titled "Today"The cell's date/time value is compared to the current date.
Today = 0Tomorrow
Section titled "Tomorrow"The cell's date/time value is compared to the day after the current date.
Tomorrow = 1Yesterday
Section titled "Yesterday"The cell's date/time value is compared to the day before the current date.
Yesterday = 2