M
Mister Softie
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.
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.