To start I am using Excel 2007 and any help would be greatly appreciated.

I want to know is there a method of having faded text in a cell (This name will be the cell title) and as you write into the cell this name will disappear and be substituted for whatever is written in the cell (not as faded text).
Is this possible? It's kind of like what you would see in online registration forms.

Regards,
David