ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell fill colors in Excel change when copying to a new book (https://www.excelbanter.com/excel-discussion-misc-queries/102323-cell-fill-colors-excel-change-when-copying-new-book.html)

jkbond67

Cell fill colors in Excel change when copying to a new book
 
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.

Gord Dibben

Cell fill colors in Excel change when copying to a new book
 
The source workbook may have had its colors modified under
ToolsOptionsColorModifyCustom.

This is a workbook only setting and when colored cells are copied to another
workbook, the colors become that of the target workbook.

In order to have the cells not change when copied to the target WB, you must
import the colors to the target WB.

With both WB open, select target WB and ToolsOptionsColors and "Copy colors
from"

Pick the source WB from the dialog box and OK


Gord Dibben MS Excel MVP

On Mon, 31 Jul 2006 13:10:02 -0700, 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

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



All times are GMT +1. The time now is 10:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com