File>Page Setup>Sheet.
Checkmark "Black and White"
You also could use Conditional Formatting to color the cells until users entered
something which would un-color the cells.
Format>Conditional Formatting>Formula is: =cellref=""
Pick a color and OK your way out.
Gord Dibben MS Excel MVP
- Show quoted text -
First of all, thanks for your help. When I check the black and white
box, it works--- however, there are some headings that I would like to
remain in color (which I didn't say in my first message-- sorry). I
know I should spend a time trying to figure out the conditional
formatting. Nevetheless, I would appreciate if you could walk me
through it so that I can keep some of the headings on the form in
color (on the printout) and still not have the shading show up when
printed. I want several headings to remain in red and a few in blue.
I look forward to your help,
Thanks again