Re: Color and Size

Tech-Archive recommends: Fix windows errors by optimizing your registry

See in-line responses.

On Tue, 9 Oct 2007 14:12:39 -0600, "Tom Brown" <Nospam@xxxxxxxxxx> wrote:

Ed,

Thanks for the help. I think I can use that formula. I have not had a chance
to work with it other than to give it quick try. I assume there is a way to
automatically make that happen on each page.

If by "page" you mean each work***, you will have to do each ***
individually.

Did you (or anyone?) have any comment on the question about how to eliminate
the vast amount of unused cells so that the file size is something more
reasonable for emailing?

Excel worksheets have a fixed number of rows and columns. These cannot be
deleted. If not used, file size will not be any larger.

If Excel thinks the used range on a work*** is much larger than you think it
should be see Debra Dalgleish's site for methods of taming the used range on a
work***.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP


Thanks,

Tom


"Ed Ferrero" <ed@xxxxxxxxxxxxxxxxxxx> wrote in message
news:O7P02KSCIHA.1184@xxxxxxxxxxxxxxxxxxxxxxx
Hi Tom,

Use conditional formatting. Set the "Formula is" format to
=MOD(ROW(A1),2)=1 and the format to a pattern fill.

Ed Ferrero
www.edferrero.com




.

Quantcast