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"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extraction 12
Sum a column 2
IF Statement that's conditional on multiple IF Stmts in other cell 1
Non Leap Years I want to show 28, leap years show 29 in an"IF" 3
Conditional Formatting for a range situation 4
vlookup with multiple values 3
php mysql code not working on server 2
IIF stmt in query 7

Back
Top