Font Colours 1

[PETEHO]

I have 68 fields with a different formula in each. I want the result to show a different colour for a positive or negative result. Is there a way of writing a formula to say IF {Multiple fields} < 0
then crRed
else crBlack. Seems pretty simple but either you cant do it or I am simple

Hoping you can help

Pete

 

[lbass]

If you select all the fields (or lasso them), you can then go to format->font->color->x+2 and enter:

if currentfieldvalue < 0 then crRed else crBlack

-LB

 

[PETEHO]

Thanks for your help, saved me a load of work