put zero in blank cell using conditional formatting

T

Terry

Win XP Pro
Office XP

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

Terry
 
G

Gary''s Student

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

font
border
pattern
 
M

Marcelo

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:
 
T

Terry

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