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

    Changing color of calculated-read only field based on conditions


      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