format the color of just 1 word in a formula?

[retygh45]

Any help is appreciated. I have a formula that compares 2 values, then gives a value:

formula:
if field1 = field2 then "GOOD", else
"BAD"

Then I put this into another formula:

"The overall intake for " & {?date range} & "was" & {formula}

I know how to use the font color formatting to format the entire formula, but is there a way to do it just on the formula? If the formula = "Bad" I want to format it red, if it's "good" to format it green.

Thanks!

 

[IdoMillet]

Option 1: use HTML tags and turn on the "interpret as HTML" format option.

Option 2: drag the pieces into a text object. This allows you to format each piece separately.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[retygh45]

Option 2: Awesome! I didn't know I could do that! Thanks!