A very simple conditional formatting question
 

Excel 2003

I want cell G4 conditionally formatted if a zero (0) is entered, but
no action if left blank. To simply program "G4=0" formats the cell
when empty because zero and null evaluated as the same? But when I use
this formula it works...

=AND(G4<"",G4=0)

So, is this the recommended hoop to jump through to make it work or is
there a better way?

Thanks,
Melina

A very simple conditional formatting question
 

zero and null evaluated as the same?

Yes

=AND(G4<"",G4=0)
is this the recommended hoop to jump through to make it work

Yes

--
Biff
Microsoft Excel MVP


"Mel" wrote in message
...
Excel 2003

I want cell G4 conditionally formatted if a zero (0) is entered, but
no action if left blank. To simply program "G4=0" formats the cell
when empty because zero and null evaluated as the same? But when I use
this formula it works...

=AND(G4<"",G4=0)

So, is this the recommended hoop to jump through to make it work or is
there a better way?

Thanks,
Melina

A very simple conditional formatting question
 

That is as good a way as any.

--
__________________________________
HTH

Bob

"Mel" wrote in message
...
Excel 2003

I want cell G4 conditionally formatted if a zero (0) is entered, but
no action if left blank. To simply program "G4=0" formats the cell
when empty because zero and null evaluated as the same? But when I use
this formula it works...

=AND(G4<"",G4=0)

So, is this the recommended hoop to jump through to make it work or is
there a better way?

Thanks,
Melina

A very simple conditional formatting question
 

Hi,

Your title is conditional formatting but you aren't doing conditional
formatting. If you are then the formula in conditional formatting should be

=AND(A1<"",A1=0)

Second question - is null and 0 the same. In most cases yes but not all
cases. the following formula returns #NULL! =A1:A10 B1:B10 which is not
equal to 0.

I realize that this is an obscure point, but...

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mel" wrote:

Excel 2003

I want cell G4 conditionally formatted if a zero (0) is entered, but
no action if left blank. To simply program "G4=0" formats the cell
when empty because zero and null evaluated as the same? But when I use
this formula it works...

=AND(G4<"",G4=0)

So, is this the recommended hoop to jump through to make it work or is
there a better way?

Thanks,
Melina

A very simple conditional formatting question
 

Thanks, Biff.

'Just wanted to be sure I missed anything. <g

-Melina


On Feb 16, 3:51*pm, "T. Valko" wrote:
zero and null evaluated as the same?

Yes

=AND(G4<"",G4=0)
is this the recommended hoop to jump through to make it work

Yes

--
Biff
Microsoft Excel MVP

"Mel" wrote in message

...

Excel 2003

I want cell G4 conditionally formatted if a zero (0) is entered, but
no action if left blank. To simply program "G4=0" formats the cell
when empty because zero and null evaluated as the same? But when I use
this formula it works...

=AND(G4<"",G4=0)

So, is this the recommended hoop to jump through to make it work or is
there a better way?

Thanks,
Melina

A very simple conditional formatting question
 

I'm doing conditional formatting.

-Melina

On Feb 16, 4:06*pm, Shane Devenshire
wrote:

Your title is conditional formatting but you aren't doing conditional
formatting. *If you are then the formula in conditional formatting should be

A very simple conditional formatting question
 

You're welcome!

--
Biff
Microsoft Excel MVP


"Mel" wrote in message
...
Thanks, Biff.

'Just wanted to be sure I missed anything. <g

-Melina


On Feb 16, 3:51 pm, "T. Valko" wrote:
zero and null evaluated as the same?

Yes

=AND(G4<"",G4=0)
is this the recommended hoop to jump through to make it work

Yes

--
Biff
Microsoft Excel MVP

"Mel" wrote in message

...

Excel 2003

I want cell G4 conditionally formatted if a zero (0) is entered, but
no action if left blank. To simply program "G4=0" formats the cell
when empty because zero and null evaluated as the same? But when I use
this formula it works...

=AND(G4<"",G4=0)

So, is this the recommended hoop to jump through to make it work or is
there a better way?

Thanks,
Melina