how do i change (or add) colour to the worksheet tabs (in excel)

[Guest]

I used to be able to do this, but: how do you change the colour of the
worksheet tabs in Excel? I'm working with a whack of tabs and would like to
give each one a different colour - but I can't for the life of me remember
how to do it.

Thanks!

AL

 

[Peo Sjoblom]

Right click sheet tab and select tab colour, of course it was implemented in
2002 I think so if you use an earlier version it won't work

 

[Roger Govier]

Hi

The feature came in with Xl2002, so provided you are using that version
or later, then right click on sheet tab>Tab colour.