I have a formula made with jcalx on http://demo.missionfamily.org/formula/
There is a read-only field marked ##A13## which displays calculations based on other fields of the equation.
The values in that field are either negative or positive depending on whether the company is making profit or loss.
What I would like to do it make it's background red when the value in it becomes negative and return it to normal when it is positive (basically assign it a class in real-time and take it out in the same way).
If you follow this example you can get positive or negative results:
When you load the page the value is positive so set class 'positive'
Just change the value ni ##A9## to 20 and the value in ##A13## will become negative so set class negative
Please remember that various other combinations of the formula would produce negative results in ##A13## so all have to be considered. Realistically I need the check to be made onBlur of every field that can be edited.
thanks in advance