Condition - Date is

Applies the selected style to the cell when the cell contents is formatted as date and the condition is one of the available date interval in the drop-down list.

• Today: applies the cell style if the cell date contents is today.

• Yesterday: applies the cell style if the cell date contents is yesterday.

• Tomorrow: applies the cell style if the cell date contents is tomorrow.

• Last 7 days: applies the cell style if the cell date contents is in the last 7 calendar days.

• This week, Last week and Next week: applies the cell style if the cell date contents is in this week, last week and next week respectively. The start and end of the week is locale dependent.

• This month, Last month and Next month: applies the cell style if the cell date contents is in this month, last month and next month respectively.

• This year, Last year and Next year: applies the cell style if the cell date contents is in this year, last year and next year respectively.