You are hoping in Ask an Excel Question -forum.
Your thread gives image to do something with Workbook Theme Colors
... but You text could mean something else...
Could You create a sample Excel-file which samples, which will show as clear as possible Your hopes?
Many things are possible ...
I have a continued project here that has many sheets in it. I want to be able to make some consistency for heading colors and perhaps a system that I can select all of the headings for expenses to be blue background like I have done with some of it. Maybe green for incomes.
Basically I think they should be named ranges to make it easier to change all of each named range.
I am not sure how to make a named range across multiple worksheets but different ranges of cells included in that range. Like for instance I can call it 'Headings' as the named range.
Your file was that show/hide comments thread...
Have You tried conditional formatting?
You should also try to read ... how to use ranges?
But even then ... there cannot be any 'maybe' ... Ps. Term Workbook Theme Colors has reserved for other use.