You can't. Not with a formula. Look up Conditional Formatting in Help.
That will do what you want. HTH Otto
"exutable" wrote in
message ...

Hey how would I change the font/cell color with a formula, example:
=IF(B6="green", fontcolor=green, fontcolor=red)


--
exutable
------------------------------------------------------------------------
exutable's Profile:
http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535363