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.