Copy Cells Fill Color
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!
|