Crystal Cross tab conditional colour formating of the current field crystal 8.5

I have a report that is a cross tab in Crystal 8.5 I am wanting to have the figures in the crosstab print red if they are a negative figure.

I have tried the following in format eidtor, font tab and then colour formula
If Sum(CurrentFieldValue) > 0 then crred else crblack, but then I get everything in red.
I have also tried:
If (CurrentFieldValue) > 0 then crred else crblack, but I still get everything in red

I have also tried:
If Sum(CurrentFieldValue) > 0 then crred else crblack under the number tab, custom style, negatives formula
But with this all figures dissapear and don't display

What simple thing am I missing??
Who is Participating?
mlmccConnect With a Mentor Commented:
Unless you missed typed it shouldn't it be < rather than >

If (CurrentFieldValue) < 0 then crred else crblack

nicbak13Author Commented:
Amazing what another set of eye's does.  Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.