Ask Experts Questions for FREE Help !
Ask
    kvinay_00's Avatar
    kvinay_00 Posts: 36, Reputation: 1
    Junior Member
    		  
    #1

    Nov 8, 2012, 01:37 AM
    Background text in a cell
    I am trying to create a form normal excel sheet and want to provide a guide to the participant on what information to put in the cells. I want t a faint text in the cells as an instruction which will disappear as someone starts typing in that cell. Can anyone help with a method that would work within Excel versions 2003-2007/ 2010?

    Thanks in advance
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Nov 11, 2012, 10:20 PM
    You can enter the text in the cell, for example "Enter Address".

    Then use conditional formatting to test the value of that cell. If the cell = "Enter Address" then format the font as grey.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

In excel when I'm on sheet1 a1 cell and I want sheet2 c1 cell text appear sheet1 b1? [ 10 Answers ]

In excel which type of symbol we use when I'm on sheet1 a1 cell and I want text of sheet2 c1 appear in sheet1 b1. Tell me the formula

How To Add Text Background In Dreamweaver? [ 2 Answers ]

Hi, I created a website which has a very colourful background image so when I put text on it you cannot read the text properly. I used to use a program called Namo Web Builder and in this there was a function which put a background around the text you was typing. Check out...

Div background not covering all text [ 8 Answers ]

In the area div.content, I have a background image with the text over it in the div.body-text. Resizing the window (narrow) makes the background image not go all the way to the bottom of the text, with a space that has no background, just text. I've come to a roadblock trying to make the background...

Cell Phone Text Problem [ 1 Answers ]

I have LG mobile phone. But Now I can't type sms from it.The first letter can type but others can't.Eg:type Aaaaaaaa, can't type B C .next button type only D others cant. Solve my problem. Thanks Dinendra

Looking for cell company with unlimited min & text [ 3 Answers ]

Right now I have verizon wireless and our bill for 4 phones is 250.00 a month. Our plan is up in 2 months and our next plan will only have 2 phones. I am looking for a cell company that has unlimited calling and unlimited text for a reasonable rate. Oh yeah and good coverage we are on the road a...

View more questions Search