We can colour the name tab of the sheet as per our requirement as shown below in the screenshot.
Let’s see how to colour the sheet name as shown below with the help of couple of steps.
Right click on the tab you want to colour, go to Tab colour and select your colour.
Hope this helped.