Text Background that disappears when user enter value

[Tennisguuy]

I am not sure if this can be done but I want to create cells on sheet named Auto that instructs the user what to input and then disappears when the value is entered. For example, in cells L53:L153 I want the text to show 7389 and it cells M53:M153 I want the text to show 03499 and it cells N53:N153 I want the text to show 23499.

Is that possible.

 

[JoeMo]

Joe I tried that and that just enters 7398 into each cell. It doesn't put it in the background. Sorry I forgot to answer your other question if they enter a value in the cell I wanted the background to disappear and if they delete the value then I would want it to reappear.

I don't understand what and where a cell's "background" is or how to access it. Can you elaborate?

 

[Tennisguuy]

Fluff,

I am not sure if I did it correctly but I copied the code your wrote by right clicking on the sheet and then selecting view code then I pasted the code. Is the code supposed to put 7398 in each cell as a background.

 

[Tennisguuy]

Joe, I am not sure what you mean by last reply but what I meant was that I don't know how to enter text as a background(ie. watermark).

 

[JoeMo]

Joe, I am not sure what you mean by last reply but what I meant was that I don't know how to enter text as a background(ie. watermark).

It's possible to put a background under all cells on a sheet using: Insert>Page Setup>Background, but that sequence won't work for a specific range and the background remains when entries to the cells are made. I'm unaware of any range-specific background setting procedure.

 

[Tennisguuy]

Ok Joe thanks I wasn't sure so I though I would ask. Thanks for responding appreciate it

 

[Michael M]

Why not put the required text into a comment.....when the user clicks on the cell, the value will appear.

 

[Tennisguuy]

Michael thanks but I wanted it visible without having to click on the cell