Windows 2000 Professional
Office 2000 Professional


I have a text box whose content is dependent on the results of a formula
on another worksheet. Basically, if the result of the formula is
greater than zero, the text box says "Unfavorable". If the result is
less than or equal to zero, the text box says "Favorable".

In cell FF31, I have the following formula:

=IF(FF300,CONCATENATE("FYTD unfavorable to goal:
",TEXT(ABS(FF30),"#.##%")),CONCATENATE("FYTD favorable to goal:
",TEXT(ABS(FF30),"#.##%")))

The text box on the chart is simply "=FF31"


I'd like to add formatting to the text such that the "unfavorable"
statement font will be red and the "favorable" statement font will be
green. Is this even possible?

Thanks in advance for any help you can provide.

Rita Palazzi
Project Engineer
FedEx Express - Global Trade Systems