Sunday, September 18, 2016

Changing the Color Palette in Excel 2007 [Anwsered]

Changing the Color Palette in Excel 2007

I have seen other posts that state to follow the following procedures:

Start Excel, and then open the workbook.Click the Microsoft Office Button, and then click Excel Options.Click Save.Next to Choose what colors will be seen in previous versions of Excel, clickColors.Click the color that you want to change, and then click Modify.Use one or more of the following procedures:To replace the selected color on the palette with a different standard color, click theStandard tab, and then click the color that you want.To change the hue or another aspect of the selected color, click the Custom tab, and then change the options.Click OK.Repeat steps 5 through 7 as needed, and then click OK.Click OK to close the Color dialog box.Click OK to close the Excel Options dialog box.

And I save the workbook and then when I open a new Excel 2007 workbook I go back to Excel Options to use the color palette from another workbook and select my saved color palette workbook. But that doesn't seem to change anything when I hit the Fill Button. Maybe what I want can't be done. I would like to be able to hit the Fill button and in the drop down section of the Theme Colors or Standard Colors see my custom colors. Am I missing something with how I am trying to set this up?