Conditional formatting to test blank text cell
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))
|