API usageSpreadsheet APIEnumerationXlTimePeriodsOn this pageXlTimePeriodsAsk a question The time period for conditional formatting. Type Enumeration Values "xlToday" "xlYesterday" "xlTomorrow" "xlLast7Days" "xlLastWeek" "xlThisWeek" "xlNextWeek" "xlLastMonth" "xlThisMonth" "xlNextMonth"