formula that displays color

[metiz]

hello

I'm using this formula in a worksheet and I was wondering íf it can be
adjusted to display the text in a certain color:

=ALS(GEMIDDELDE(B1:E1)>7,9;"A";ALS(GEMIDDELDE(B1:E1)>=7;"B";ALS(GEMIDDELDE(B1:E1)>=6;"C";ALS(GEMIDDELDE(B1:E1)>=5;"D";"E"))))&"
= "&VAST(GEMIDDELDE(B1:E1);1)


("ALS" and "GEMIDDELDE" stand for "IF" and "AVERAGE")

the outcome of this formula is something like: "c=6.0" is it possible
to display the LETTER in a color: anything under 5.5 displays the
letter in red, anything above 5.5 displays the letter in green

thanks in advance

 

[Bob Phillips]

You could use conditional formatting (See
http://www.contextures.com/xlCondFormat01.html), but this would colour the
whole cell not just the letter.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)