I set up alternate colors in rows. But when I go to copy a formula down, or
the contents down (or right), the color of the cell is copied also.
How can I copy the contents only and leave the background color of the cells
the same?

Try Copy PasteSpecial Value, or Copy PasteSpecial Formula

Vaya con Dios,
Chuck, CABGx3



"wade_aus10" wrote:

I set up alternate colors in rows. But when I go to copy a formula down, or
the contents down (or right), the color of the cell is copied also.
How can I copy the contents only and leave the background color of the cells
the same?

Wade

If you use Conditional Formatting to color the alternate rows, you won't be
bothered by the copying.

Select rows 1 to 50 then FormatConditional FormattingFormula is:

=MOD(ROW(),2)=1

FormatPattern

The alternate rows will be the color you picked.

When dragging formulas down the color won't change.

Will also retain the alternate coloring when sorting or inserting/deleting rows.


Gord Dibben MS Excel MVP

On Tue, 28 Nov 2006 08:10:02 -0800, wade_aus10
wrote:

I set up alternate colors in rows. But when I go to copy a formula down, or
the contents down (or right), the color of the cell is copied also.
How can I copy the contents only and leave the background color of the cells
the same?

Use Conditional Formatting to color the rows. See
www.cpearson.com/excel/banding.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"wade_aus10" wrote in message
...
I set up alternate colors in rows. But when I go to copy a formula down, or
the contents down (or right), the color of the cell is copied also.
How can I copy the contents only and leave the background color of the
cells
the same?