You can use Conditional Formating for this (Format menu). Just add the
conditions that the values should be exactly OK or ERROR and set the colors
you want.

Hope this helps,
Miguel.

"kvadre" wrote:


I have a cell where i have a if

=if(a2<a3;"OK";"ERROR")

What I would like is that it still says OK or ERROR but also have a
color. Green for ok red for error..

Any ideas


--
kvadre
------------------------------------------------------------------------
kvadre's Profile: http://www.excelforum.com/member.php...o&userid=37023
View this thread: http://www.excelforum.com/showthread...hreadid=567451