How to permanently save a custom fill color?

[Ian Y]

I use a custom fill color frequently. After I create it, it becomes one of Recent Colors in the Fill Colors menu. However, after I close and re-open Excel, that custom fill color disappeared and I have to create it again to use it.

I tried a possible solution and saved a xlt file which contains the custom fill color in the XLStart folder. But that didn't work. The location I saved the file is C:\Program Files\Microsoft Office\root\Office16\XLSTART

 

[Ian Y]

When in the VBE, CTRL+G should launch the immediate window.

You can also get to it by selecting it in the 'view' section of the VBE's ribbon.

Thanks. It showed the location of the the correct XLStart folder, and it turned out to be at a different place (C:\Users\Administrator\AppData\Roaming\Microsoft\Excel\XLSTART). But after I put a .xltx file in there, I still can't see the custom color in the Fill Color menu after I open Excel.

Not sure what I did wrong. The .xltx file I put in there has its first cell applied with a random fill color I created for this test.

 

[Georgiboy]

When i tested it, i put a standard xlsx file in there, i formatted to the colour i wanted and then made the cell 'No fill' again.

Try with a standard xlsx file?

 

[Ian Y]

When i tested it, i put a standard xlsx file in there, i formatted to the colour i wanted and then made the cell 'No fill' again.

Try with a standard xlsx file?

Thank you. That kinda worked.

But every time I open a different Excel file, the xlsx is automatically opened, too. And the different Excel file does not have the custom color; only the xlsx has it.