I have searched for previous postings on these subjects, but no luck.

I have a workbook with 5 worksheets. They are tabbed along the bottom. 4
of them are assorted columns linked to the master worksheet. I would like
to have each worksheet assign a contrasting color to alternating rows each
time I click on the tab. I frequently add new rows to the first page and
then resort the other worksheets. But, if I have manually colored the rows,
eventually they are a mess with many rows of the same color bunched
together. The intent is to make it easier to read and follow the data on
one line across the sheet.

Is there any practical way to automate this function? I have columns from A
to K and rows up to 600.

This leads me to the other question about limiting the size of the
worksheet. I know it should probably be posted under a separate thread but
it is sort of related to this color question. When I send this workbook via
email, it is over 4 meg in size. If I could get rid of the rows after 600
and the columns past K, it should be smaller in size. I don't know how many
rows are possible but I scrolled to 11,000 and then tried to Delete them.
How many more are there?

Thanks,

Tom