I am trying to satisfy 2 criteria in order to change the color of a cell:
I hilighted cells b27:b56) and then went to conditional formatting and
entered this formula. I want the b column to turn blue if the adjacent cell
in the C column is greater than zero. I am spinning my wheels on this.
Thanks in advance for your help. You folks always come through for me!

=and(c17:c56>0,isblank(b17:b56))

Select B17:B56

then with B17 as the active cell use

=C17>0

or if B needs to be blank

=AND(B17="",C17>0)

since you are using relative cell references they formatting will carry over
to the other cells that are selected and
change to

=C18>0
=C19>0

and so on


--


Regards,


Peo Sjoblom


"Andyjim" <(E-Mail Removed)> wrote in message
news:07AF8E51-CCCE-492A-9F5E-(E-Mail Removed)...
>I am trying to satisfy 2 criteria in order to change the color of a cell:
> I hilighted cells b27:b56) and then went to conditional formatting and
> entered this formula. I want the b column to turn blue if the adjacent
> cell
> in the C column is greater than zero. I am spinning my wheels on this.
> Thanks in advance for your help. You folks always come through for me!
>
> =and(c17:c56>0,isblank(b17:b56))

Select the entire range to be formatted but in the formula just reference
the individual cell, not the entire range:

=AND(COUNT(C17),C17>0,B17="")

--
Biff
Microsoft Excel MVP


"Andyjim" <(E-Mail Removed)> wrote in message
news:07AF8E51-CCCE-492A-9F5E-(E-Mail Removed)...
>I am trying to satisfy 2 criteria in order to change the color of a cell:
> I hilighted cells b27:b56) and then went to conditional formatting and
> entered this formula. I want the b column to turn blue if the adjacent
> cell
> in the C column is greater than zero. I am spinning my wheels on this.
> Thanks in advance for your help. You folks always come through for me!
>
> =and(c17:c56>0,isblank(b17:b56))

Thanks so much! Works well.

"Peo Sjoblom" wrote:

> Select B17:B56
>
> then with B17 as the active cell use
>
> =C17>0
>
> or if B needs to be blank
>
> =AND(B17="",C17>0)
>
> since you are using relative cell references they formatting will carry over
> to the other cells that are selected and
> change to
>
> =C18>0
> =C19>0
>
> and so on
>
>
> --
>
>
> Regards,
>
>
> Peo Sjoblom
>
>
> "Andyjim" <(E-Mail Removed)> wrote in message
> news:07AF8E51-CCCE-492A-9F5E-(E-Mail Removed)...
> >I am trying to satisfy 2 criteria in order to change the color of a cell:
> > I hilighted cells b27:b56) and then went to conditional formatting and
> > entered this formula. I want the b column to turn blue if the adjacent
> > cell
> > in the C column is greater than zero. I am spinning my wheels on this.
> > Thanks in advance for your help. You folks always come through for me!
> >
> > =and(c17:c56>0,isblank(b17:b56))
>
>
>

You cannot test a range for >0 or ISBLANK.

Must be done one cell at a time.

Select B17:B56 then enter this formula in CF>Formula is:

=AND($C17>0,ISBLANK($B17))

Note the $ signs to lock the column but not the row.


Gord Dibben MS Excel MVP

On Thu, 10 Jan 2008 10:09:02 -0800, Andyjim <(E-Mail Removed)>
wrote:

>I am trying to satisfy 2 criteria in order to change the color of a cell:
>I hilighted cells b27:b56) and then went to conditional formatting and
>entered this formula. I want the b column to turn blue if the adjacent cell
>in the C column is greater than zero. I am spinning my wheels on this.
>Thanks in advance for your help. You folks always come through for me!
>
>=and(c17:c56>0,isblank(b17:b56))