Multiple Colored Sheet Tabs

[D3FCON]

I now reference my sheets by color as a quick index, However i would like to sub reference a few.

Do you know if it is possible to have more than just one color in a sheet Tab?

I would like to be able to have 2 colors or 3 even on some.

Excel 2016

 

[My Aswer Is This]

Do you mean you want you sheet tab to be named Red and the next sheet tab to be named Blue.

Or do you mean you want your sheet Tab color to be red.

And by more then one color. Do you mean you want one third of your tab color to be blue another third of the tab to be colored Red. Etc.

 

[D3FCON]

For example i have a tab colored red, On the main page of my spreadsheet there is an index menu, I click on the nane and all tabs in the color are shown only.

I want to have said tab multi colored so i can call on it from another color also.

IE. Red|White tab. Not just the one solid color.

 

[My Aswer Is This]

If you right click on the Tab and choose Tabcolor you have thousands of colors to choose from.

Show me the code you use to do this:
You said:

I click on the nane and all tabs in the color are shown only.​

 

[D3FCON]

For example i have a tab colored red, On the main page of my spreadsheet there is an index menu, I click on the nane and all tabs in the color are shown only.

I want to have said tab multi colored so i can call on it from another color also.

IE. Red|White tab. Not just the one solid color.

 

[D3FCON]

Yeah i get that, Thousands of Single colors. I want to change a Tab into Two Colors, Not just one [red|blue]

 

[My Aswer Is This]

This is beyond my knowledgebase.
I will continue to monitor this thread to see what I can learn.

 

[Michael M]

I don't know about 2016, but earlier versions do not have the option to multicolor OR shade!!

 

[My Aswer Is This]

It could be done like this:

Sub Color_My_Tab()
'Modified 11/11/2018 7:55:22 PM  EST
Sheets(1).Tab.Color = RGB(251, 145, 212)
End Sub

But then that may be considered one color

I know of no way to say 1 half the Tab should be colored Blue and the other half Red.