Text Box font color

[Rita Palazzi]

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(FF30>0,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

 

[Andy Pope]

Hi,

One way, without code, would be to use 2 cells. One returning text if
favorable the other if not.
Then in the chart use 2 linked textboxes. Format 1 as Red and linked to the
unfavorable cell the other green linked to the favorable cell.

Cheers
Andy