Change automatic border color
Black borders are ugly and take attention away from the data in tables. I would like to be able to switch the default border color to gray, but I can’t do that either at the workbook or the sheet level. This means that I have to manually change the border color or paste formatting every time I add borders.
I’ve tried setting preferences in the Workbook and Worksheet templates in the XLStart folder, but the border preference does not stick.
This is not to be confused with the default gridline color, which can be set in the Advanced Excel option.
In the Worksheet/Workbook templates in the XLStart folder, did you change the settings for the Normal Style? (Styles are not the best explained, but can provide great formatting. But I am still learning about them after being thwarted many a-time.)
Kenneth Barber commented
You can use the Format Painter.