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 ?
|