ig.excel.FormatConditionTimePeriod
Dependencies
-
lastMonth
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 9
The cell's date/time value is compared to the month before the current one.
-
lastSevenDays
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 6
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.
-
lastWeek
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 5
The cell's date/time value is compared to the week before the current one, as defined by the CalendarWeekRule.
-
nextMonth
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 8
The cell's date/time value is compared to the month after the current one.
-
nextWeek
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 4
The cell's date/time value is compared to the week after the current one, as defined by the CalendarWeekRule.
-
thisMonth
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 7
The cell's date/time value is compared to the current month.
-
thisWeek
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 3
The cell's date/time value is compared to the current week, as defined by the CalendarWeekRule.
-
today
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 0
The cell's date/time value is compared to the current date.
-
tomorrow
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 1
The cell's date/time value is compared to the day after the current date.
-
yesterday
- Type:
- ig.excel.FormatConditionTimePeriod
- Default:
- 2
The cell's date/time value is compared to the day before the current date.