Is it possible to print without the colored cells printing any color?

[Paul B]

Marvin, try this, file, page setup, sheet, under print check black & white

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **

 

[Ken Wright]

Not silly at all - Format background will effectively do all cells,
whereas you might want to colour certain cells only, but not have it print out.

 

[Marvin Hlavac]

Not silly at all - Format background will effectively do all cells,
whereas you might want to colour certain cells only, but not have it print

out.




That would be a nice feature, I agree. But for my immediate need the
"background" solution will suffice.

 

[Marvin Hlavac]

This is rather silly question It's not that very important but if there is
an easy solution it would make my sheet nicer to look at. I'd like to be
able to assign color to some cells but when printing I don't want the color
to be printed.

Is it possible? Most likely not :--(

 

[Marvin Hlavac]

Hi Paul,

Thanks but please disregard my silly question. I didn't know it was possible
to set sheet background which is non-printable. (Format, Sheet, Background)
That solved my problem.

 

[Ken Wright]

Good stuff - Just didn't want you to feel that you shouldn't have posted that's
all. It's always better to ask than to simply keep quiet - what can it hurt,
and that's what the groups are here for. Anyway, glad you are sorted.