Thread: How can I copy down, the contents of a cell and not color
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default How can I copy down, the contents of a cell and not color
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?


Reply With QuoteReply With Quote