6 Replies Latest reply on Feb 13, 2013 12:55 PM by 51sunshine

    Changing color of calculated-read only field based on conditions

    51sunshine

      I need help creating a script that would make a calculated-read only field change color if a condition is met.  Should the script placed in the calculated event?

       

      The fields are as follows:

       

      CourseNum (auto sum calculates 11 numeric different fields)

      A1P (numeric calculated read only field)

      AP (numeric calculated read only field)

      HighA (the sum of A1P and AP) - this is also a calculated read-only filed

       

      So the condition would be:

       

      if CourseNum >20 and HIGHA >=50%

      then change the background color to yellow

       

      I have the form but I don't think I can upload it