Cell color depending on statement

K

kvadre

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
 
M

Miguel Zapico

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.
 
D

Dave Peterson

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
 
B

Bob Umlas

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
 
Top