Hello,
how do I change the color of a cell depending on the value?
ex:
something needs to be done in 24 hrs. I have created a VBA when I press the reset button, the timer value updates. says "5 hours till deadline", "20 hours till deadline" so on and so forth.
I want it so the closer we get to the deadline, the color should change from green (say 5hrs elapsed) to red (20hrs elapsed). Any help would be appreciated. thnx.
also, is it possible to update the timer automatically, without me hitting the reset button? (not important right now but just curious)
thanx in advance.
Bookmarks