Need formula - conditional formatting - ran out of conditions!

S

Sandy

Hello -

I have the following conditions already in conditional formatting for each
cell (it merely turns the cell color green - color #35, to be exact):
Condition 1
Formula Is =IF(G9="N/A",IF(I9="",TRUE,FALSE),FALSE)
Condition 2
Formula Is =IF(G9="No",IF(I9="",TRUE,FALSE),FALSE)
Condition 3
Cell Value Is equal to 0

PROBLEM: I have at least one more condition I need to add:

If G is blank, turn the corresponding cell in Column I to green

If for the last statement there is some way of combining If G="" Or I="0"
turn the cell green, that would work, but I can't seem to figure out how to
do this.

Any help will be greatly appreciated!
 
G

Gary''s Student

If G="" Or I="0" is the same as MAX((G1=""),(I1="0")) as if either are true
the MAX=>TRUE=>1
 
S

Sandy

Hello Gary's Student -

Thanks for your response!

I tried =IF(MAX((G5=""),(I5="0")),TRUE, FALSE). It didn't work. The cell I
tried it on has a 0 in it and the cell turned white when I put this in as the
third condition. Did I write it wrong?

I need a formula that says if G5 is blank OR if I5 is zero, turn the cell
green.
 
R

Ron Rosenfeld


See suggestions inline:
I have the following conditions already in conditional formatting for each
cell (it merely turns the cell color green - color #35, to be exact):
Condition 1
Formula Is =IF(G9="N/A",IF(I9="",TRUE,FALSE),FALSE)
=AND(G1="N/A",I1="")

Condition 2
Formula Is =IF(G9="No",IF(I9="",TRUE,FALSE),FALSE)
=AND(G1="No",I1="")

Condition 3
Cell Value Is equal to 0

PROBLEM: I have at least one more condition I need to add:

If G is blank, turn the corresponding cell in Column I to green

If for the last statement there is some way of combining If G="" Or I="0"


=OR(G1="",I1=0)

--ron
 
S

Sandy

Ron -

Thanks so much for your response!

I only had the chance to try it on one cell because it's late at night, but
it sure looks like it's going to work!
 
R

Ron Rosenfeld

Ron -

Thanks so much for your response!

I only had the chance to try it on one cell because it's late at night, but
it sure looks like it's going to work!

You're very welcome. Post back if you have a problem.

If you do need a fourth condition, you might be able to set one as the baseline
condition, depending on your expected range of values.




--ron
 

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

Top