AnsweredAssumed Answered

Conditional format calculation

Question asked by EricaJackson on Sep 14, 2012
Latest reply on Sep 14, 2012 by EricaJackson


Conditional format calculation


     Hi all

     I need help with a conditional format. With previous forum help I have been able to create a "stopwatch" that is I am able to use timestamps for start and stop times and I am able to add the minutes together to get the cumulative time. (Thanks!!!)

     What I would like to do now is add formatting to that calculation field so that it changes color after 30 minutes or a different color after 60 minutes... etc.

     Also with the other fields, what is the formula to get them to change to a color when any data is entered in them.  Thanks again!