Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Change cell color dependin on date ...
Hi,
Looking for some help please ... Column A contains a list of date values (e.g. 11/04/2005). I'm looking for a way to change the cell color based on the following criteria ... If the date falls earlier than today but no earlier than a week before today then cell color to be red. If the date falls earlier than today but no earlier than two weeks before today then cell color to be yellow. If the date falls earlier than today but no earlier than three weeks before today then cell color to be green. Can anyone offer a solution to this please? Should I be looking at conditional formatting or should I use VBA? Many thanks. -- T. Denford. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Due date - change cell color | Excel Worksheet Functions | |||
how can I get a cell to change color by date to indicate expiery t | New Users to Excel | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
cell color change based on due date | New Users to Excel | |||
Change cell color dependin on date ... | Excel Worksheet Functions |