| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 | |||
| Formula with text and reference to a date cell | Excel Discussion (Misc queries) | |||
| How do I change the value in cell based on a future date | Excel Discussion (Misc queries) | |||
| How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Extract date from cell | Excel Worksheet Functions | |||
Threaded Mode
