| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour change by date
I have searched for an answer to this but haven't managed to nail it:
I wish to colour cells containing future dates within 30 days of TODAY() red. This bit is straightforward, but I wish to ignore all dates which have passed (ie yesterday and beyond) How can I modify the CF line =D7-TODAY()<30 to do this? Or would code be better? Ideally, I'd like something like Between 0 and 30 days = red, 31 - 60 days amber, 61 - 90 days = green. Thanks in advance -- Traa Dy Liooar Jock |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Colour change by date
You need to add an and
=and(D7-TODAY()<30, D7-TODAY() 0) "Jock" wrote: I have searched for an answer to this but haven't managed to nail it: I wish to colour cells containing future dates within 30 days of TODAY() red. This bit is straightforward, but I wish to ignore all dates which have passed (ie yesterday and beyond) How can I modify the CF line =D7-TODAY()<30 to do this? Or would code be better? Ideally, I'd like something like Between 0 and 30 days = red, 31 - 60 days amber, 61 - 90 days = green. Thanks in advance -- Traa Dy Liooar Jock |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Colour change by date
Nice and simple
Thanks Joel -- Traa Dy Liooar Jock "Joel" wrote: You need to add an and =and(D7-TODAY()<30, D7-TODAY() 0) "Jock" wrote: I have searched for an answer to this but haven't managed to nail it: I wish to colour cells containing future dates within 30 days of TODAY() red. This bit is straightforward, but I wish to ignore all dates which have passed (ie yesterday and beyond) How can I modify the CF line =D7-TODAY()<30 to do this? Or would code be better? Ideally, I'd like something like Between 0 and 30 days = red, 31 - 60 days amber, 61 - 90 days = green. Thanks in advance -- Traa Dy Liooar Jock |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to change the cell Colour when a date has been surpassed? | Excel Discussion (Misc queries) | |||
| change cell colour according to date..... | Excel Worksheet Functions | |||
| change font colour after a date has expired | Excel Discussion (Misc queries) | |||
| Change colour based on date | Excel Worksheet Functions | |||
| Change cell colour by date | New Users to Excel | |||
Linear Mode
