Shading in excel
FilePage SetupSheet.
Checkmark "Black and White"
You also could use Conditional Formatting to color the cells until users entered
something which would un-color the cells.
FormatConditional FormattingFormula is: =cellref=""
Pick a color and OK your way out.
Gord Dibben MS Excel MVP
On Fri, 27 Jun 2008 17:28:12 -0700 (PDT), dcb1 wrote:
I created a form in excel. I shaded (filled in cells with color)
areas where I want the user to enter in data. However, I don't want
the shading printed out. Does excel have the capability to do this?
I would appreciate anybody's help,
Thanks
|