| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Need help with an embedded IF statement | Excel Worksheet Functions | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| copying cell names | Excel Discussion (Misc queries) | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Linear Mode
