| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a cell be changed on a certain date
I have Excel 2003 and I want a cell to change colors when the date i put in
the cell is within six months of todays date. Is this possible? if A1 has 12NOV08 and A2 has 12NOV09 how can I get A2 to change to red when its six months from todays date |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto enter current date in cell when another changed | Excel Worksheet Functions | |||
| STORE THE DATE & TIME THE VALUE HAS CHANGED IN A CELL | Excel Discussion (Misc queries) | |||
| Insert date when a cell is changed | Excel Discussion (Misc queries) | |||
| How to auto insert date in one cell when another is changed | Excel Worksheet Functions | |||
| can i see the date the last time a cell was changed? | New Users to Excel | |||
Threaded Mode
