Color Pallet

E

EarlyBirdie

I have two spreadsheets created on different PC's (possibly with different
versions of Excel). When I copy data with background coloring from one sheet
to the other, the background fill colors change. I also notice that the
color pallet on the tool bar is different on each of the two spreadsheets.
How do I get the colors to copy without changing or how do I change the color
pallet so it matches the origin spreadsheet?--
EarlyBirdie
 
Y

Youngergirl44

To reset the color palette: Tools - Options - Color tab - Reset button

In my experience, resetting the palette will correct the formatting of
existing cells.
 
S

Shane Devenshire

Hi,

To copy a color pallette from one workbook to another open both workbooks
and move to the one into which you want to copy the color pallette.

Choose Tools, Options, Color, open the drop down list under Copy colors from
and choose the other file.
 
E

EarlyBirdie

Thanks, that worked.
--
EarlyBirdie


Youngergirl44 said:
To reset the color palette: Tools - Options - Color tab - Reset button

In my experience, resetting the palette will correct the formatting of
existing cells.
 
E

EarlyBirdie

Thanks, that worked
--
EarlyBirdie


Shane Devenshire said:
Hi,

To copy a color pallette from one workbook to another open both workbooks
and move to the one into which you want to copy the color pallette.

Choose Tools, Options, Color, open the drop down list under Copy colors from
and choose the other file.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top