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:E 1)=7;"B";ALS(GEMIDDELDE(B1:E1)=6;"C";ALS(GEMIDDE LDE(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


--
metiz
------------------------------------------------------------------------
metiz's Profile: http://www.excelforum.com/member.php...o&userid=33769
View this thread: http://www.excelforum.com/showthread...hreadid=544166