Conditional formatting - date alert
Solved
zozo
-
Cory -
Cory -
Hello everyone,
In Excel 2007, I have a column "D" filled with dates, and I would like to use
the conditional formatting options to create an alert for my overdue dates and therefore color the background of the cells in red if the date is less than today's date() - 15 days, and nothing for the other cells.
But I can't seem to apply the conditional formatting to the entire column; I have to do it cell by cell for it to work.
Here is the formula I am using in the conditional formatting:
=$D:$D<today />
I must be missing something, but what?
Can you help me?
Thank you in advance.
In Excel 2007, I have a column "D" filled with dates, and I would like to use
the conditional formatting options to create an alert for my overdue dates and therefore color the background of the cells in red if the date is less than today's date() - 15 days, and nothing for the other cells.
But I can't seem to apply the conditional formatting to the entire column; I have to do it cell by cell for it to work.
Here is the formula I am using in the conditional formatting:
=$D:$D<today />
I must be missing something, but what?
Can you help me?
Thank you in advance.
3 réponses
Hello,
in "conditional formatting", write the following formula:
=$D1-TODAY()<=15
and choose the formatting you want to apply.
Then in the "applies to" area, select the entire range you want it to apply to.
--
As the great philosopher Mick Jagger said: "You can't always get what you want"
Help me to help you!
in "conditional formatting", write the following formula:
=$D1-TODAY()<=15
and choose the formatting you want to apply.
Then in the "applies to" area, select the entire range you want it to apply to.
--
As the great philosopher Mick Jagger said: "You can't always get what you want"
Help me to help you!
zozo
Thank you tibouuh, it works perfectly.
Cory
Your explanation was very clear. Thank you.