View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish Debra Dalgleish is offline
external usenet poster
 
Posts: 2,979
Default Cell fill colors in Excel change when copying to a new book

When you copy cells to a new workbook, they use colours from that
workbook's palette. You could copy the palette from the original
workbook to the new workbook:

Open the old workbook and the new workbook
In the new workbook, choose ToolsOptions
On the Color tab, in the 'Copy Colors from' dropdown, choose the old
workbook
Click OK

jkbond67 wrote:
Whenever I copy a sheet to a new workbook, the fill colors of the cells
change to a darker, or different color. I want them to remain the same as
when I copied them.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html