Need formula - conditional formatting - ran out of conditions!
 

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!

--
Sandy

Need formula - conditional formatting - ran out of conditions!
 

If G="" Or I="0" is the same as MAX((G1=""),(I1="0")) as if either are true
the MAX=TRUE=1
--
Gary''s Student


"Sandy" wrote:

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!

--
Sandy

Need formula - conditional formatting - ran out of conditions!
 

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.

--
Sandy


"Gary''s Student" wrote:

If G="" Or I="0" is the same as MAX((G1=""),(I1="0")) as if either are true
the MAX=TRUE=1
--
Gary''s Student


"Sandy" wrote:

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!

--
Sandy

Need formula - conditional formatting - ran out of conditions!
 

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

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

--


Gary


"Sandy" wrote in message
...
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!

--
Sandy

Need formula - conditional formatting - ran out of conditions!
 

On Thu, 8 Sep 2005 16:24:02 -0700, "Sandy"
wrote:

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

Need formula - conditional formatting - ran out of conditions!
 

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!

--
Sandy


"Ron Rosenfeld" wrote:

On Thu, 8 Sep 2005 16:24:02 -0700, "Sandy"
wrote:

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

Need formula - conditional formatting - ran out of conditions!
 

On Thu, 8 Sep 2005 21:42:01 -0700, "Sandy"
wrote:

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!

--
Sandy

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