This is probably addressed somewhere in the forums, but I have not yet perfected how to search effectively in here, so if my question is a common one, feel free to direct me to the appropriate threads.

I have a simple formula field that subtracts the value of one field from another. I would like for the text of the formula field to be red when it is a negative value.

As always, your input is very much appreciated!



Edit: BTW, I have tried using
if (formula) < 1
then red
else black

I couldn't keep the formula and the if/then/else statement together in one formula field. It changed all my values to zero.

Edited by adavis - 16 Nov 2012 at 5:30am

Right Click on the Field/ Formula you want to format-> Select Format Field->Font Tab->Click X-2 Box Next to color-> Write Condition Accordingly:
if {Field}<0 then crRed