View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Conditional - empty cell

Hi. I must be doing something wrong ...

I want to have a conditional format when cell A1 is empty.

I set:

Formula is to:

="len(a1)=0"

Even when the cell is empty, the formatting will not occur. Any ideas?

Thanks,
Mike.