inserting "-" where cells are blank

[paramnayak]

dear all,

I want to insert "-" (without inverted commas) in cells which are blank using conditional formatting. I am using the formula =isblank(a4) ,where say a4 is the blank cell , and putting "-" in custom number format but its not working.

Same formula is working when i am putting some fill colour.

thanx and rgds

 

[Somendra Misra]

Hi Param,

CF are not meant for putting default text in cells & also Custom number format can only format content of cells say you can format to show 0 as "-" , but if the cell is blank, I don't think it is possible.

May be some VBA trick can do the action.

Regards,

 

[sgmpatnaik]

@paramnayak

i am not sure what you think, if the cell is blank then the "-" symbol to be appear if cell is not blank then what?
the result may be like this

=If(A4="","-","")

Then you will get the "-" if the a4 is blank

Thanks

SP

 

[Utkarsh]

Hi,
There are 2 methods for your problem.
1. -
First type "-" in any one cell & copy it by Ctrl+C. Then,
Use Go To window i.e. Select your range , press "F5". Click on "Specials".
Then select "Blanks" & press Ctrl+V or Paste & all blank cells will replaced by "-".

2. -
Just select your range. Press Ctrl+H (Find & Replace). In find window don't type anything. In replace window type "-". Press Replace All. & Done.


Hope this will solve your problem.

 

[paramnayak]

dear friends,
thanx for the reply. As somendra is saying , i guess this is not possible using CF.