Distinguish each worksheet by change worksheet tab color in excel. Learn how to easily color hundred of worksheet in this blog
To Download the exercise File and Follow along click Here
Here is the Code
Sub ChangeColors()
Dim WS As Worksheet
Dim IndexColor As Long
IndexColor = 50000
For Each WS In Worksheets
WS.Tab.Color = IndexColor
IndexColor = IndexColor + 50000
Next WS
End Sub
change worksheet tab color in excel by following this simple steps
Watch the Video
If you are interested to learn from the main people at Microsoft, you can read more from the article on changing the background tab color in excel.
Mohammed
Mr. Nabil, you are an excellent instructor, that we have never seen like you before.
God bless you
nabilmourad
Thank you Mohammed
Truly appreciated
Herman
I’ve never enjoyed tutorials as much as I’m enjoying yours.
Thank YOU