Hi,

Use conditional formatting.

Select the cell then
Format|Conditional format - Cell Value is- 'Equal to'
In the input box enter your text prompt
Click format and select a light grey colour for the font - OK

Mike

"mckillmt" wrote:

I want to have 'in-cell' instructions (i.e. "Enter Length Here"). I want the
instructions to be in a light grey, and when the user enters their data (into
the same cell as the instructions), the number is in black. How to I get the
cell to automatically change colors from grey to black when a user enters
data?