put zero in blank cell using conditional formatting

[Terry]

Win XP Pro
Office XP

I wish to create a third condition format by placing a zero in blank cells
please?

Terry

 

[Guest]

Can't do that with conditional formatting. Can only set:

font
border
pattern

 

[Terry]

Thanks Gary....I had got "bogged" down with it hence post.

Terry

 

[Guest]

it is not possible,

you can, select the range, press F5, special, chose empty cells only, type 0
and CTRL + Enter

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Terry" escreveu:

 

[Terry]

Thanks Marcelo...I am unable to find "empty cells only" in special, so
unable to complete.
Regards
Terry...UK

 

[Bob Umlas]

Blank, not "empty"

Thanks Marcelo...I am unable to find "empty cells only" in special, so
unable to complete.
Regards
Terry...UK
type