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

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

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

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" <Sandy@discussions.microsoft.com> wrote in message
news:5FE0904A-88F4-4DF4-A47C-F603EB469CF0@microsoft.com...
> 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

On Thu, 8 Sep 2005 16:24:02 -0700, "Sandy" <Sandy@discussions.microsoft.com>
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

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" <Sandy@discussions.microsoft.com>
> 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
>

On Thu, 8 Sep 2005 21:42:01 -0700, "Sandy" <Sandy@discussions.microsoft.com>
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