Need formula - conditional formatting - ran out of conditions!

[Guest]

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!

 

[Guest]

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

 

[Guest]

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.

 

[Gary Keramidas]

you can check this site out. one of the posters here, bob phillips, has some
input

http://www.xldynamic.com/source/xld.CFPlus.Download.html

 

[Ron Rosenfeld]

Hello -

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

 

[Guest]

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!

 

[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