1. I need to change a cell's data, and have another cell indicate the time when it was changed. The problem I have is when I use =IF(D2>0,NOW()) it updates all of my cells to that time. I need to track inidvidual cell time entries. Would like to 24 hour time ie 1345
2. Next problem is how to do a system comparison of how long it has been since the cell was changed like a conditional format to change color of the above cell. I have no idea how to compare against the system timer or other counter chronomter to track how long it has been since a cell changed.
Thank you!
2. Next problem is how to do a system comparison of how long it has been since the cell was changed like a conditional format to change color of the above cell. I have no idea how to compare against the system timer or other counter chronomter to track how long it has been since a cell changed.
Thank you!