How to make Fill Color static in the Quick Access Toolbar?

[Eloise T]

As you can see on my Quick Access Toolbar (see picture below), I have [Save] [Undo] [Redo] [All borders] [Thick Bottom Border] and [No Borders].

I would like to add a blank/white background Fill Color to the Quick Access Toolbar. The problem is when I change the Fill Color to blank/white and then add it to the Quick Access Toolbar, it behaves just like the "upper" Fill Color and will not remain white but changes along with the upper Fill Color. Is there a way to make it static like I've been able to make the three border styles so the Fill Color in the Quick Access Toolbar never changes from white and the "upper" Fill Color changes as normal?

 

[vletm]

Could You find it from next link?
https://support.office.com/en-us/ar...-toolbar-f733e1a6-53b1-4388-a609-173d03895ab7

 

[Eloise T]

Could You find it from next link?
https://support.office.com/en-us/ar...-toolbar-f733e1a6-53b1-4388-a609-173d03895ab7

No. It appears as though what I want to do is not possible. It's no problem to move the Fill Color to the Quick Access Toolbar, but apparently it can't be limited to only one color. Am I missing something?

 

[vletm]

Eloise T
You could make 'own button' to sheet as You need/like
without any 'Quick Access Toolbar'.

 

[Debaser]

There isn't a native button for that so you would have to write a macro and assign it to the QAT.

 

[Eloise T]

Hopefully I can find a macro out there (Internet) which creates a button and assigns it to the QAT I can convert for my own needs.

 

[AlanSidman]

Eloise,
Let make sure I understand what you want the Macro to do. If I understand, you need the macro to fill the background of a selection of cells to be white. Is this correct or am I missing something?

 

[Eloise T]

Eloise,
Let make sure I understand what you want the Macro to do. If I understand, you need the macro to fill the background of a selection of cells to be white. Is this correct or am I missing something?

I would like to add a blank/white background Fill Color button to the Quick Access Toolbar. ...so your question is essentially correct. See picture at top. I have QAT buttons for 3 different Borders...[All borders] [Thick Bottom Border] and [No Borders] and would like a white background Fill Color button in the QAT. Thank you in advance for any assistance.

 

[AlanSidman]

If you place this macro in your file (personal.xlsb), then

look at this link on how to add a button to the QAT that will initiate your macro
https://support.office.com/en-us/ar...a-button-728c83ec-61d0-40bd-b6ba-927f84eb5d2c

Sub ColorWhite()
Selection.Interior.ColorIndex = 2
End Sub

 

[Eloise T]

If you place this macro in your file (personal.xlsb), then

look at this link on how to add a button to the QAT that will initiate your macro
https://support.office.com/en-us/ar...a-button-728c83ec-61d0-40bd-b6ba-927f84eb5d2c

Sub ColorWhite()
Selection.Interior.ColorIndex = 2
End Sub

Thanks Alan. Works like a charm!