put zero in blank cell using conditional formatting
 

Win XP Pro
Office XP

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

Terry

put zero in blank cell using conditional formatting
 

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

font
border
pattern

--
Gary''s Student
gsnu200711

put zero in blank cell using conditional formatting
 

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

Terry
"Gary''s Student" wrote in message
...
Can't do that with conditional formatting. Can only set:

font
border
pattern

--
Gary''s Student
gsnu200711

put zero in blank cell using conditional formatting
 

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:

Win XP Pro
Office XP

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

Terry

put zero in blank cell using conditional formatting
 

Thanks Marcelo...I am unable to find "empty cells only" in special, so
unable to complete.
Regards
Terry...UK
"Marcelo" wrote in message
...
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:

Win XP Pro
Office XP

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

Terry

put zero in blank cell using conditional formatting
 

Blank, not "empty"

"Terry" wrote in message
...
Thanks Marcelo...I am unable to find "empty cells only" in special, so
unable to complete.
Regards
Terry...UK
"Marcelo" wrote in message
...
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:

Win XP Pro
Office XP

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

Terry