| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Making cells change color after a specified period of time.
Hi,
Does anyone know how to color cells after 30 days. Thanks for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making cells change color after a specified period of time.
after 30 days of what?
-----Original Message----- Hi, Does anyone know how to color cells after 30 days. Thanks for your help . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making cells change color after a specified period of time.
Do you mean:
The date in the cell <NOW() - 30 ? In which case you could use conditional formatting using that as a criteria. Or do you mean, the cell has not been changed in the last 30 days. One possibility is to capture changes to a worksheet by hooking the _Change event. Then on a hidden sheet, paste the current date/time in the cell of the same row/column. If neither, then you'll have to clarify. Rob "Marc" wrote in message ... Hi, Does anyone know how to color cells after 30 days. Thanks for your help |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Making cells change color after a specified period of time.
Sorry. There will be a cells with a dates and from those
dates anyhting over 30 days will change color -----Original Message----- Do you mean: The date in the cell <NOW() - 30 ? In which case you could use conditional formatting using that as a criteria. Or do you mean, the cell has not been changed in the last 30 days. One possibility is to capture changes to a worksheet by hooking the _Change event. Then on a hidden sheet, paste the current date/time in the cell of the same row/column. If neither, then you'll have to clarify. Rob "Marc" wrote in message ... Hi, Does anyone know how to color cells after 30 days. Thanks for your help . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change font color when making changes | Excel Discussion (Misc queries) | |||
| average rate of change per given time period between 2 moments in time of a value | Excel Worksheet Functions | |||
| Change colour once a certain time period passed | Excel Discussion (Misc queries) | |||
| Changing text/color after a time period? | Excel Discussion (Misc queries) | |||
| Making cells change color after a specified period of time. | Excel Programming | |||
Linear Mode
