| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Timestamp a cell when row is updated.
I am looking for a solution.
My spreadsheet has 5 columns that i do not want this to affect. The 6th column is "Last Updated". When i write comments in any cell after H i want it to put the updated date and time into "Last Updated" in that row. Another addition to this would be to check the last updated date, if it is upto 3days from today then turn green, upto 5days yellow and more than 7days red! I hope someone can help! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel cells randomly don't get updated unless each cell is updated | Excel Discussion (Misc queries) | |||
| How do I insert a Timestamp when a cell changes? | Excel Worksheet Functions | |||
| Timestamp And Store Cell Value | Excel Programming | |||
| Need a 'last updated' timestamp for a web query | Excel Worksheet Functions | |||
| How can a timestamp in an Excel row be automatically updated if a. | Excel Worksheet Functions | |||
Threaded Mode
