Excel 2016 - Change Default Color In Cell Color Drop Down Box

[Billb2]

Is there a way to change the default color in the background color drop down box? Yellow is the default, but I want blue.

...and to be picky, I just want the default color changed for one particular spreadsheet when it opens, not every one that opens.

Thanks for your help.....

 

[bruceb]

Can you show a screen shot of exactly what area or box you want to change the color ?

 

[Billb2]

I want the yellow (default) color in the drop down box to be blue when the spreadsheet first opens.

 

[bruceb]

Have a look here .. it may help .. you may have to create a custom theme for that worksheet

http://www.officetooltips.com/excel..._colors_that_excel_uses_for_chart_series.html

Or maybe here:

https://support.office.com/en-us/ar...e-themes-63e65e1c-08d4-4dea-820e-335f54672310

 

[Billb2]

Na, those change Excel for all spreadsheets. I just want the default blue on one particular spreadsheet.
What I want is to pIck blue from drop down, save and exit and when the sheet opens again blue should be the default (instead of always defaulting back to yellow).

 

[bruceb]

Maybe try here: http://www.techrepublic.com/forums/discussions/excel-default-select-function-highlight-color/
And I think excel will let you create multiple themes. You just need to use your custom theme when you want it and the default theme for all other work sheets.
You could also look here and post a request at tips.net .. a good site run by Allan Wyatt and very informative about Word and Excel. http://www.tips.net/

 

[Cica Ogier]

I want the yellow (default) color in the drop down box to be blue when the spreadsheet first opens.

Hi There did you find the answer to your question? I want to do the same and cant find the answer anywhere. Thanks

 

[bruceb]

This tip mainly is for Word but I think Mr. Wyatts idea of using a Macro to set the color may work in Excel as well. You may need to play with it to get the color you want.
I am not too well versed in using macros, but this may start you in the right direction.
https://wordribbon.tips.net/T000144_Changing_the_Default_Highlighting_Color.html

Changing the default highlight color:
On the Home tab of the ribbon, the default color for the Text Highlight tool is yellow. Larry wonders if there is a way to change the default so that it is, instead, "No Color."


The answer depends on what you mean by "default color." If you mean that the highlighting will be something other than yellow (including "No Color") when you first start Word, then the answer is no. There is no built-in ability to specify a default color according to this definition.


However, if your definition of "default color" means that what Word uses the next time you use the Text Highlight tool, then the answer is yes. You see, if you use the drop-down color selector next to the tool, whatever color you pick (including, again, "No Color") becomes the "default" color for all subsequent uses of the tool during your current session in Word.


Of course, you can change the highlight color when you first start Word by using an AutoExec macro to set the color. The macro using this special name, when stored in your Normal template, runs whenever you start Word, so it is a great place to specify the color you want. Here's how such a macro would look:


Sub AutoExec()
Options.DefaultHighlightColorIndex = wdNoHighlight
End Sub

 

[Billb2]

Thanks.