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!

Copy Cells Fill Color
 

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!

Copy Cells Fill Color
 

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!

Copy Cells Fill Color
 

How does column A gets its colors?


Gord Dibben MS Excel MVP


On Wed, 4 Feb 2009 12:08:16 -0800, FrankM
wrote:

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!

Copy Cells Fill Color
 

Gord, Thank you for replying. column A gets its color from the database
extract. I don't know why the database choose to only fill column A. But
since I am using a Macro to format the sheet and set the Print settings, I
was hoping I could also use the Macro to color columns B:I with the same
color from column A.


"Gord Dibben" wrote:

How does column A gets its colors?


Gord Dibben MS Excel MVP


On Wed, 4 Feb 2009 12:08:16 -0800, FrankM
wrote:

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!

Copy Cells Fill Color
 

I can't believe that a data extract from a database would bring in colored
data.

Does column A contain Conditional Formatting?

If so, can you copy that CF to columns B:I


Gord

On Wed, 4 Feb 2009 16:05:56 -0800, FrankM
wrote:

Gord, Thank you for replying. column A gets its color from the database
extract. I don't know why the database choose to only fill column A. But
since I am using a Macro to format the sheet and set the Print settings, I
was hoping I could also use the Macro to color columns B:I with the same
color from column A.


"Gord Dibben" wrote:

How does column A gets its colors?


Gord Dibben MS Excel MVP


On Wed, 4 Feb 2009 12:08:16 -0800, FrankM
wrote:

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!

Copy Cells Fill Color
 

I don't know what to tell ya ... there is cdolor from the extract. I'm not
sure how it gets in there. I don't believe there is Conditional Formatting.

I'm surprised that some VBA wouldn't be able to copy the fill color but I
found a work around. I put some code in the Macro that copies the format of A
and does a Paste Special of the format into B:I. Unfortunately it also
changes the font format but I can live with that.

Thanks a lot for your assistance.

"Gord Dibben" wrote:

I can't believe that a data extract from a database would bring in colored
data.

Does column A contain Conditional Formatting?

If so, can you copy that CF to columns B:I


Gord

On Wed, 4 Feb 2009 16:05:56 -0800, FrankM
wrote:

Gord, Thank you for replying. column A gets its color from the database
extract. I don't know why the database choose to only fill column A. But
since I am using a Macro to format the sheet and set the Print settings, I
was hoping I could also use the Macro to color columns B:I with the same
color from column A.


"Gord Dibben" wrote:

How does column A gets its colors?


Gord Dibben MS Excel MVP


On Wed, 4 Feb 2009 12:08:16 -0800, FrankM
wrote:

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!