2 Replies Latest reply on Sep 14, 2012 9:05 PM by EricaJackson

    Conditional format calculation

    EricaJackson

      Title

      Conditional format calculation

      Post

           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!

           Erica