My understanding is the OP wants to have TWO colors of fonts within ONE
cell via a formula. Excel does not allow for this. Check out this
thread for more details...

http://www.excelforum.com/showthread...nt+colors+cell


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=473528