You can make it easier to navigate through a workbook by color-coding the worksheet tabs. For example, if your workbook contains sheets related to different projects, you can assign a different tab color to each project. Similarly, you can format tabs for incomplete worksheets with one color and completed worksheets with another. Excel offers 10 standard colors and 60 colors associated with the workbook’s current theme.
You can also apply a custom color if none of the standard or theme colors meet your needs. To change the worksheet tab color, click the tab of the worksheet you want to format.
Then, click the Home tab, click Format, and finally click Tab Color.
Excel displays the tab color palette. Click the color you want to apply to the current tab.
The tab color appears faintly when the tab is selected, but it shows more vividly when another tab is selected.
NOTE:
To apply a custom color, click More Colors, then use the Colors dialog box to choose your desired color.
NOTE:
You can also right-click the tab, click Tab Color, and then click the color you want to apply.