Cell color depending on statement
 

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

Cell color depending on statement
 

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

Cell color depending on statement
 

Take a look at Format|Conditional formatting
Cell value is
Equal to
Ok
(set a nice format)

add another condition
cell value is
equal to
error
set a nice format



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

--

Dave Peterson

Cell color depending on statement
 

Use Format/conditional formatting and enter value of OK & select format of
Green (click Format button, then Patterns tab), then click the Add button,
enter value of ERROR and select format of Red.
Bob Umlas
Excel MVP

"kvadre" wrote in
message ...

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