View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default In-Cell Instructions

You have two easy options:

1. Insert a Comment in the cell. The comment will appear wheneven a
mouse-over occurs

2. Insert a Data Validation message in the cell. The message will appear
whenever the cell is clicked.
--
Gary''s Student - gsnu200859


"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?