I have a spreadsheet extract that changes from month to month. Sometimes it
is 750 lines, sometimes 800 lines or 900 and sometimes 600.

Column A is sometimes a different color than columns B to I (these are the
only columns I'm concerned with).

I would like columns B to I to be the same color as column A.

I run a simple Macro to format print settings and column widths and so
forth. I'm hoping there is an easy code I can throw into the Macro to do the
Cell color too.

Any suggestions?

Thanks in advance!

Shoot ... one thing I forgot.

A1 could be a different color than A2 and A3 and so forth and so on. So B1,
C1, D1, E1, F1, G1, H1, I1 should all be the same as A1 and B2 ... I2 should
be the same as A2 and so forth and so on. I don't know if that will make a
different but it might. :) Again thanks in advance for any assistance.



"FrankM" wrote:

I have a spreadsheet extract that changes from month to month. Sometimes it
is 750 lines, sometimes 800 lines or 900 and sometimes 600.

Column A is sometimes a different color than columns B to I (these are the
only columns I'm concerned with).

I would like columns B to I to be the same color as column A.

I run a simple Macro to format print settings and column widths and so
forth. I'm hoping there is an easy code I can throw into the Macro to do the
Cell color too.

Any suggestions?

Thanks in advance!

Anyone?

"FrankM" wrote:

I have a spreadsheet extract that changes from month to month. Sometimes it
is 750 lines, sometimes 800 lines or 900 and sometimes 600.

Column A is sometimes a different color than columns B to I (these are the
only columns I'm concerned with).

I would like columns B to I to be the same color as column A.

I run a simple Macro to format print settings and column widths and so
forth. I'm hoping there is an easy code I can throw into the Macro to do the
Cell color too.

Any suggestions?

Thanks in advance!