remove shading when printing

[LFM]

I have a form in excel that has the unlocked cells (the ones to be filled
out) shaded so they stand out to the user. (FWIW, the form is an
application for services)

When this form prints, I would like it to print simply with no highlighted
cells showing. I want the text the user entered to show, but the background
to not show.

Secondly, I have a combo box in the upper left corner of the form called
"choose office". The user selects the office, and based on the updates, the
Address and phone/fax fields are filled in on the bottom of the form. I do
not want this combo box to be viewed on the printed form.

What is the best way to go about achieving my goals on this form?

 

[Debra Dalgleish]

You can use conditional formatting to change the cell colour when you're
ready to print. There's an example here that hides text, and you could
adapt it to remove the fill colour:

http://www.contextures.com/xlCondFormat03.html#Print

If the combo box is from the Forms toolbar:
Right-click on the combo box, and choose Format Control

 

[Gail]

LFM

To print without showing the shaded cells, on the sheet go to Print set up
and go to the Sheet tab and check the Print Black and white box

 

[Chris Lavender]

.... and to avoid printing the combo box, you can do Format
control...\Properties and uncheck Print object.


Best rgds
Chris Lav