excel formatting

[Jimhporter48]

How do I change the font color in my tabs?

[k0st4din]

Hi, right klick with mouse and see picture.
Regards

[Jimhporter48]

I knew how to change the "TAB" color. I was wanting to find out how to change the "FONT COLOR" in the tab.

[Don]

You're really not going to be able to do that like you want. The tab font color will change based on the tab's background color, but there is no way to control the font color of the tab directly.

[Jimhporter48]

Don,


Thanks. It appears that the multiple tab sheets that are in the document are colored blue but a couple of them are black. All of the tabs are the same color, I believe. Is there a way to make sure all of the tabs are the same color without going into each one individually?

Thanks.

[Don]

You could use a macro to do this, but if you only have 10 or so sheet tabs, it's really easier to just do it by hand this one time.

But if you'd like a macro, here one is:

Code: Select all

Sub Change_All_Tab_Color()


For i = 1 To Sheets.Count

    Sheets(i).Tab.ThemeColor = xlThemeColorLight1

Next i


End Sub


This will change the color of all sheet tabs in the workbook. You might have to reference the colors differently depending on the version of Excel that you are using. But, to change the color, just change "xlThemeColorLight1" to whatever you want. To get a list of all colors and their names, just do a google search or record a macro of you changing a tab's color and copy and paste the name of the color from that recorded macro into this macro.

[Jimhporter48]

Don,
Thanks, I appreciate it.
Jim