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.