Leave text in a cell when same cell has no text input.

[rastak1]

Hi all

Im trying to figure E.g. when A1 is empty i want it to equal a text.

A1 has a text "Quote No" in it permanently until other text is put in

Purpose so that they people know where to enter the applicable text.

[martindwilson]

put 0 in all cells where you want a quote number
custom format as
#,##0.00;-#,##0.00;"quote number"

[rastak1]

hi mate I putit in conditional formatting but does not work does the # equal a cell number

[martindwilson]

its a custom number format not a conditional format

[newdoverman]

You can use a TEXT BOX found on the Developer tab Controls Group.

Click on the Design Mode icon then click on Insert. Click on Text Box under Active X controls. Draw the box in cell A1.

A box with Sizing Handles will appear on the box that you have drawn. Right click this box and choose Properties. Click on Alphabetic tab. Click on the cell to the right of MAXIMUM LENGTH and enter the number of characters that you want to allow.

Click on the cell to the right of TEXT and enter the text that you want as default (Text before an entry is made) and hit enter. Click on the Categorized Tab, go to Font, Click on the button to the right and choose the font characteristics that you want.

Close the Properties box, click on the Design Mode icon to exit Design Mode.

The box should now be filled with the Default text and when you click in the box, you can make an entry.

[rastak1]

Thanks again for your replies

i have tried both methods but i still want "Quote No" with no cell input or when it is blank .

[martindwilson]

then you will need code to do that
something like

Please Login or Register  to view this content.

[rastak1]

Thanks that works !!!!!! i tried copying the code and it came back with a compile error
"ambigous name detected: worksheet_change"

i want another cell to equal something else but i get this error if i copy the code and change the cells and value

[martindwilson]

hmm see attached

[rastak1]

thanks MartinDWilson you are the man!