View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andyjim Andyjim is offline
external usenet poster
 
Posts: 70
Default Conditional formatting to test blank text cell

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))