formula that displays color
 

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

formula that displays color
 

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)

"metiz" wrote in
message ...

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(B
1: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


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