Contingut

# Condició ▸ La data és

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 dropdown list.

Per a accedir a aquesta ordre...

#### Des de la barra de menús:

Trieu Format ▸ Condicional ▸ Data

#### Des de la interfície en pestanyes:

Trieu Inici ▸ Condicional ▸ Data.

#### Des de les barres d'eines:

Data

- 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.

Temes relacionats

Formatació condicional

Ens cal la vostra ajuda!