View Single Post
  #6   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You could use conditional formatting to change the font to white, when
printing. There's an example he

http://www.contextures.com/xlCondFormat03.html#Print

Blair Scanlan wrote:
I've already tried that unsuccessfully...

"Ragdyer" wrote:


Depending on the specific printer and the color you chose to use, try:
<File <PageSetup <Sheet tab,
And *UNCHECK* "Black & White".
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Blair Scanlan" <Blair wrote in message
...

I've got cells in my worksheet that I've changed the font color and
background color the same, so the contents are not visible when viewing


the

sheet... I don't want the contents of these cells to be printed either...


Is

there a way to prevent them from printing?





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html