If the cell contains the word "name" it will not be blank.

I would suggest using FormatConditional Formatting for the cell.

Cell Value is: equal to =""

Format to a color and instruct user to enter a name in that colored cell.

When user enters their name, the color will disappear.

Watch out for Excel helping you with the =""

Sometimes it will add an extra ""


Gord Dibben MS Excel MVP


On Tue, 25 Sep 2007 08:32:01 -0700, Izo wrote:

For example, if I would like to designate a specific cell for people to enter
in a certain piece of information (such as their name), can I have the cell
display "Name" whenever it is blank, so that people know to enter their name
in that cell?