| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two part question about dates and highlighting
Hello from Steved
I have the date in cell A5 which is 11/12/06 Firstly after 24 hours are up I wold the cell E5 to be highlited with the color purple. Secondly the same as above but after 3 daysin cell F5, and also after 1 week in cell G5. Thankyou. ps there are over 100 rows. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting - dates | Excel Discussion (Misc queries) | |||
| Conditional formatting - range of dates | Excel Discussion (Misc queries) | |||
| Conditional formatting - range of dates | Excel Discussion (Misc queries) | |||
| highlighting cells which have dates later than... | Excel Discussion (Misc queries) | |||
Threaded Mode
