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:c560,isblank(b17:b56))

Select B17:B56

then with B17 as the active cell use

=C170

or if B needs to be blank

=AND(B17="",C170)

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

=C180
=C190

and so on


--


Regards,


Peo Sjoblom


"Andyjim" wrote in message
...
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:c560,isblank(b17:b56))

Thanks so much! Works well.

"Peo Sjoblom" wrote:

Select B17:B56

then with B17 as the active cell use

=C170

or if B needs to be blank

=AND(B17="",C170)

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

=C180
=C190

and so on


--


Regards,


Peo Sjoblom


"Andyjim" wrote in message
...
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:c560,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),C170,B17="")

--
Biff
Microsoft Excel MVP


"Andyjim" wrote in message
...
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:c560,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 CFFormula is:

=AND($C170,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
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:c560,isblank(b17:b56))