Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format cells by date
Dear All,
I am looking for some help formatting cells with date entries using excel 2003. I have tried using 'formula is' and '=(A1-TODAY())<300', and have seen variations on this theme in other threads, but don't seem to be able to get a formula to work with the following; Date entered into cell (not necessarily 'todays' date). Cell turns yellow when 300 days have elapsed from the date entered, cell turns red when 365 days have elapsed from the date entered (I have the cells formatted for date) Grateful for any help. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format cells by date
You need to set up 2 conditions. First condition (default) has to be:
=(A1-TODAY())<365 and format Red. Then click Add to set up the second condition: =(A1-TODAY())<300 and format Yellow. The first condition has priority over the 2nd (and 3rd). This assumes that A1 is the cell selected. Hope this helps. Pete On May 4, 4:27*pm, Simon wrote: Dear All, I am looking for some help formatting cells with date entries using excel 2003. I have tried using 'formula is' and '=(A1-TODAY())<300', and have seen variations on this theme in other threads, but don't seem to be able to get a formula to work with the following; Date entered into cell (not necessarily 'todays' date). Cell turns yellow when 300 days have elapsed from the date entered, cell turns red when 365 days have elapsed from the date entered (I have the cells formatted for date) Grateful for any help. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional format cells by date
You were very close...
First condition (red format) =TODAY()-A1365 Second condtion (yellow format) =TODAY()-A1300 Think of this as being "The distance between today and the date in A1 is more than x days" -- Best Regards, Luke M "Simon" wrote in message ... Dear All, I am looking for some help formatting cells with date entries using excel 2003. I have tried using 'formula is' and '=(A1-TODAY())<300', and have seen variations on this theme in other threads, but don't seem to be able to get a formula to work with the following; Date entered into cell (not necessarily 'todays' date). Cell turns yellow when 300 days have elapsed from the date entered, cell turns red when 365 days have elapsed from the date entered (I have the cells formatted for date) Grateful for any help. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional format for date | Excel Discussion (Misc queries) | |||
Conditional Format - Date + 7 | Excel Discussion (Misc queries) | |||
Conditional Format is date is Sat or Sun | Excel Discussion (Misc queries) | |||
Conditional format when date is near | Excel Worksheet Functions | |||
Conditional Format - Date | New Users to Excel |