Hey,
I have a simple calculator form that multiplies fieldname1*fieldname2 to show the result in fieldname3.
I want to add rules that changes the look of the Calculated Field (fieldname3) to include the following:
• If the result is >0 and <40, then the number will be green and show the text “Low”.
• If the result is >40 and <80, then the number will be yellow and include the text “Medium”.
• If the result is >80, then the number will be red and include the text “High”.
I am of the impression that I need to utilise the “Set Equation” form of fieldname3, but I can’t seem to figure out the function.
Any help would be greatly appreciated.
Tom