| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Stmt with two colors
How can I use an if stmt to determine values 0 and the results be a RED
"Stop" if 0 and a GREEN "Continue" if <0 ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If Stmt with two colors
What happens if it equals 0?
If you want to continue for values equal to 0, =IF(A10,"Stop","Continue") If you need them seperated: =IF(A10, "Stop",IF(A1<0,"Continue")) Then go to Format - Conditional Format Set the pattern to red if cell value equals "Stop" Add condition Set pattern to green if cell value equals "Continue" -- Best Regards, Luke M "kenny4golf" wrote: How can I use an if stmt to determine values 0 and the results be a RED "Stop" if 0 and a GREEN "Continue" if <0 ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting error using if then else stmt | Excel Worksheet Functions | |||
| Rounding down from .9 in an IF stmt | Excel Worksheet Functions | |||
| if stmt trouble | Excel Discussion (Misc queries) | |||
| URGENT need help with if/then stmt. | Excel Worksheet Functions | |||
| Commission Calculation with IF Stmt. | Excel Worksheet Functions | |||
Linear Mode
