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

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

On Jun 27, 7:44*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- 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

Select a range of cells that users have to enter data in.

Then follow the instructions below to set blank cells to a color.

=cellref="" where cellref is the activecell of your selection.

e.g. assuming headings are in rows 1 and 2 and you want them untouched.

Select A3:C10 then in Formula is: enter =A3=""

Conditional Formatting will apply to all cells in the range.

Those with data will have no color.........those that are blank will be colored
until users fill them in with data.


Gord

On Fri, 27 Jun 2008 18:51:52 -0700 (PDT), dcb1 wrote:

On Jun 27, 7:44*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- 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

On Jun 27, 11:17*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Select a range of cells that users have to enter data in.

Then follow the instructions below to set blank cells to a color.

=cellref="" *where cellref is the activecell of your selection.

e.g. * assuming headings are in rows 1 and 2 and you want them untouched.

Select A3:C10 then in Formula is: *enter *=A3=""

Conditional Formatting will apply to all cells in the range.

Those with data will have no color.........those that are blank will be colored
until users fill them in with data.

Gord



On Fri, 27 Jun 2008 18:51:52 -0700 (PDT), dcb1 wrote:
On Jun 27, 7:44*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- 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- Hide quoted text -

- Show quoted text -

I still need help. I am unable to figure this out. Again, I created
a form. When I print it, I want several headings (which are in color)
to remain in color when printed along with preventing the areas that
are shaded in different colors (for the user to enter data) from
printing. Could somebody please explain how to use conditonal
formatting and =cellref="" from the help I received. The more you can
break it down for me--- the better. Also, I just want to say thanks
to those that have responded--- of course I have alot to learn about
excel. I am sure I will have more questions.

Please top-post if responding to me.

I will break it down for one cell.

Select A5 which is empty

On the Menu Bar select FormatConditional FormattingCondition1.........click on
dropdown arrow and select "Formula is:"

Type in =A5="" that is two double quotes signifying a blank cell.

Hit FormatPattern and select red from the color picker options.

OK your way out.

A5 will be red until someone enters data, then it will lose the red color.

I can't get more specific than that.


Gord


On Sun, 29 Jun 2008 14:27:21 -0700 (PDT), dcb1 wrote:

On Jun 27, 11:17*pm, Gord Dibben <gorddibbATshawDOTca wrote:
Select a range of cells that users have to enter data in.

Then follow the instructions below to set blank cells to a color.

=cellref="" *where cellref is the activecell of your selection.

e.g. * assuming headings are in rows 1 and 2 and you want them untouched.

Select A3:C10 then in Formula is: *enter *=A3=""

Conditional Formatting will apply to all cells in the range.

Those with data will have no color.........those that are blank will be colored
until users fill them in with data.

Gord



On Fri, 27 Jun 2008 18:51:52 -0700 (PDT), dcb1 wrote:
On Jun 27, 7:44*pm, Gord Dibben <gorddibbATshawDOTca wrote:
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- Hide quoted text -

- 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- Hide quoted text -

- Show quoted text -

I still need help. I am unable to figure this out. Again, I created
a form. When I print it, I want several headings (which are in color)
to remain in color when printed along with preventing the areas that
are shaded in different colors (for the user to enter data) from
printing. Could somebody please explain how to use conditonal
formatting and =cellref="" from the help I received. The more you can
break it down for me--- the better. Also, I just want to say thanks
to those that have responded--- of course I have alot to learn about
excel. I am sure I will have more questions.