Highlight in "view layout"
 

Hello, I have a couple of forms in which users enter data in specific cells
and then all the formulas are referenced to those cells and so on... Is there
a way to "highlight" those cells where users enter data, to make it more
"user-friendly" ? The thing is that I wouldn't like in this case to have a
different fill pattern or border or whatever in those cells when I print the
sheet, I was thinking about something that you can see while you are editing
the document and so on but that doesn't appear when you print it, just to
serve the purpose to guide the users who are filling the form...

,thanks

Highlight in "view layout"
 

Go ahead and color the input cells.

In your Print SetupSheet set for Black and White or Draft Quality.

The colors will not show on printing.

Note: there are methods of forcing your users to only select the input cells in
a particular order which you designate.

See Bob Phillips site for info on that.

http://www.xldynamic.com/source/xld.xlFAQ0008.html


Gord Dibben MS Excel MVP

On Mon, 19 Jun 2006 06:52:02 -0700, Ed wrote:

Hello, I have a couple of forms in which users enter data in specific cells
and then all the formulas are referenced to those cells and so on... Is there
a way to "highlight" those cells where users enter data, to make it more
"user-friendly" ? The thing is that I wouldn't like in this case to have a
different fill pattern or border or whatever in those cells when I print the
sheet, I was thinking about something that you can see while you are editing
the document and so on but that doesn't appear when you print it, just to
serve the purpose to guide the users who are filling the form...

,thanks