Conditional - empty cell
Remove the quotes and see what happens.
=LEN(A1)=0
Are you sure the cell is empty...........no extra spaces?
If you enter =LEN(A1) in B1 does it return a 0
Gord Dibben MS Excel MVP
On Wed, 22 Apr 2009 16:39:01 -0700, Mike
wrote:
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.
|