Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Default fill color change
I have a spreadsheet in which i've created specific fill colors. When I try
to open the spreadsheet from a new workbook, the colors go back to default and the sheet looks horrible (i.e bright orange-red where light mint green should be). I have to send this on to management and would hate to have the spreadsheet look great on my screen but have loud, eye-irritating colors when they try to open it. Can someone please help? |
#2
|
|||
|
|||
Colors travel with workbooks.
So if you've customized your color set in workbook A (say worksheet1), then copy worksheet1 to a different workbook (say B) that doesn't have the same customized settings, then all your colors will change to workbook B's colors. If that's what you mean by opening a spreadsheet from a new workbook, then you could change the customized colors for that new workbook (any existing colors in that new workbook could change--depends on how you've used your colors). Anyway, open the new workbook (bad colors) and the old workbook (good colors). With the bad colors workbook active: tools|options|colors tab Use the "copy colors from" box and point at the "good color" workbook. Remember to save your new workbook with the good colors. And you may want to check if you've changed the existing colors to something less desirable. If you want to learn more about how excel deals with colors, you may want to visit David McRitchie's site: http://www.mvps.org/dmcritchie/excel/colors.htm Cheyenne wrote: I have a spreadsheet in which i've created specific fill colors. When I try to open the spreadsheet from a new workbook, the colors go back to default and the sheet looks horrible (i.e bright orange-red where light mint green should be). I have to send this on to management and would hate to have the spreadsheet look great on my screen but have loud, eye-irritating colors when they try to open it. Can someone please help? -- Dave Peterson |
#3
|
|||
|
|||
Colors modified through ToolsOptionsColorModify are a property of the
workbook and are not a global change to Excel. These color mods can be imported to another workbook. I am confused(easily done) by your term "open the spreadsheet from a new workbook". What exactly do you mean by this? Do you mean "copy the worksheet to a new workbook"? "Spreadsheet" is the generic term for an application like Excel that is used for calculation. Lotus is a "spreadsheet" program. Quattro Pro is a "spreadsheet" program. Excel has "workbooks" which contain "worksheets". Gord Dibben Excel MVP On Tue, 14 Dec 2004 08:51:08 -0800, "Cheyenne" wrote: I have a spreadsheet in which i've created specific fill colors. When I try to open the spreadsheet from a new workbook, the colors go back to default and the sheet looks horrible (i.e bright orange-red where light mint green should be). I have to send this on to management and would hate to have the spreadsheet look great on my screen but have loud, eye-irritating colors when they try to open it. Can someone please help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save as Default folder | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
Auto Fill Options | Excel Discussion (Misc queries) | |||
Fill area beneath a scatter plot | Charts and Charting in Excel | |||
Is there a way to change the default shading color ? | Excel Discussion (Misc queries) |