I am currently building a worksheet to help in dispatching drivers. My goal and what I need help with is code that allows a dispatcher to see his fleet and how much time they have left before overtime. The needs for the code will be for each driver that see the row change color, say 1 cell equals .5 hours till it hits 10 hours. As the day progresses cells to the right will change color, green. When the driver hits overtime, 10 hours the color, red will again change.
The code will start when a driver starts time is entered
Wow I bet I made this as clear as mud...
Thanks for any help in advance