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.

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.

Conditional - empty cell
 

Gord:

It was the quotes .... I removed them and it works fine.

Thanks for your help.

Mike.

"Gord Dibben" wrote:

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.