View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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