ExcelBanter - If Stmt with two colors

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - If Stmt with two colors (https://www.excelbanter.com/excel-worksheet-functions/169786-if-stmt-two-colors.html)

kenny4golf

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 ?

Luke M

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 ?

All times are GMT +1. The time now is 04:58 AM.