Hi everyone. Im in the army and we use excel to track how long our soldiers have been in suit. Im trying to see if there is a way that you can put a timer in a cell to turn it red once the timer has bern started and surpasses 45 minutes. Id like to be able to start and stop the timer and have it hit yellow when it hits approximately 30 minutes. Can anyone help? Or have any idea how to do something like this with out having to manually change it and watch the clock the whole time?
Bookmarks