I work with farily complex Excel worksheets which require print outs
as both hard copy and PDF. I normally keep the formatting as they are
and select [Black and White] in [Page Setup] [Sheet], as this
preserves the integrity of the financial model while printing out a
clean copy for the enduser.

However, this function basically converts everyting color-coded to
black & white, including cell shading patterns; I normally accentuate
certain important cells by shading them in black and using a white
font color. While I want the output to be black & white, I do want
to preserve this particular formatting pattern. Is there any way to
preserve this, perhaps through conditional formatting or other tricks?
Thanks very much.

Do you have File|Page setup|Sheet tab|Black and white checked
(or Draft checked)
(xl2003 menu system)

If no, is your printer (under control panel) set for color?

And you're sure that you're printing to a color printer?



"Mister Softie <" wrote:

I work with farily complex Excel worksheets which require print outs
as both hard copy and PDF. I normally keep the formatting as they are
and select [Black and White] in [Page Setup] [Sheet], as this
preserves the integrity of the financial model while printing out a
clean copy for the enduser.

However, this function basically converts everyting color-coded to
black & white, including cell shading patterns; I normally accentuate
certain important cells by shading them in black and using a white
font color. While I want the output to be black & white, I do want
to preserve this particular formatting pattern. Is there any way to
preserve this, perhaps through conditional formatting or other tricks?
Thanks very much.

--

Dave Peterson