Not without using a macro. And if the tab color changes the number will not
change.
__________________________________________________ _______________________



"excel" wrote in message
ups.com...
Can I have a cell in a worksheet (any cell at this stage) that shows
say a '1' if that worksheet tab colour is green, and a '2' if that
worksheet tab colour is red, nothing if there is no colour?, and if
so, how would i do that?

TIA
Esra