Reversed-out text

[Wendall Oakes]

I would like to use the "reversed-out" text.
However when I change my background color to blue "example" and
print, the background will print dark or in blue. I would like to us
the reversed -out text and have it print normal without changing m
setting back. Is there a way to do this

 

[Earl Kiosterud]

Wendall,

You can use the Black and White print option in File - Page setup - Sheet
tab. All text will be in black, and no background colors will print.

Othewise, I think you'd have to use the Before_Print event and change the
formatting, do the print, then change it back. Probably easiest by using a
Style (Format - Style) for the cells to be changed. Your macro need only
modify the style, and all the cells using that style will change.