How to Display Text in a Cell Telling another user What they should input in that Cell

Hi,

I have spent a long while today Googling and trying to achieve this in Excel 2007, but I also use Excel 2010.

I have been asked to create a spreadsheet, for non spreadsheet users to complete, which is locked down except for the fields they can complete, which will all appear white.

I would like the cells the users can complete, to show in grey text, what they should type in that cell (e.g. "Type Client Name here" etc.) but for them not to have to delete the text in that cell before typing in the actual Client Name etc.

I can achieve a similar result by displaying a message through Data Validation, but have seen (what I hope I am describing clearly) done by someone else, and think in what I am trying to achieve this would be better. However I cannot seem to find how to do this myself!

I hope I've described what I am trying to achieve understandably, and would greatly appreciate any help in how to achieve this.

Many thanks.