How can I format cells for viewing, but not printing?

[Dbriltz]

I create elaborate worksheets and would like to have the cells that need
periodic updating to stand out in bold or a different font from the other
(formula-driven) cells, but I do not want them to appear differently when
printed. Has anyone developed an idea that works for this?

Also, I would like to have certain rows on my spreadsheet for information
that would never print out, but would be within my print range. Is there a
way to print without them other than to hide the rows?

 

[FSt1]

hi
the only thing i can think of is to suggest that you record 2 macros.
preprint macro would un-format all and hide rows.
postprint macro would re-format all and unhide rows.

you did say that you "create elaborate worksheets " so it might be a pain to
record it all but once done, unformating and reformating is just a button
click.

my thoughts
Regards
FSt1

 

[Dave Peterson]

Ron de Bruin has some code that "hides" cells when you print.
http://www.rondebruin.nl/print.htm#Hide
Look for "Make the Font white of a range"

It changes the font color to white so that the white font on a white file makes
the cell look blank.

You could do the same kind of thing--but change the fill color to white, print,
then change the fill color back to what you want.

Record a macro when you change a the formatting and then change it back and
you'll have the guts of the code.

====
Another option if you're not using format|Conditional formatting.

In an out of the way cell, put an X.
Then use conditional formatting that looks at that cell to format it
distinctively.

Then before you print, you could clear that cell.

Select the range
Format|conditional formatting
Formula is: =$z$99="X"
(change the address to what you used)
and give it a distinct format.