If Stmt with two colors

  • Thread starter Thread starter kenny4golf
  • Start date Start date
K

kenny4golf

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 ?
 
What happens if it equals 0?
If you want to continue for values equal to 0,
=IF(A1>0,"Stop","Continue")
If you need them seperated:
=IF(A1>0, "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"
 
Back
Top