Conditionally change font color - crystal reports

I am trying to make a text box conditionally invisible by tying it to the value of adj开发者_StackOverflow中文版acent revenue column.. I tried using the formula - if command.revenue > 5000 then crgreen else crnocolor , in the font formula editor but it is not working. Need help in doing this the right way. Thanks

You should conditionally suppress the value instead of making it invisible; set the suppression formula for the textbox to

Command.Revenue > 5000