View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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