Condition depending on tab colour

  • Thread starter Thread starter excel
  • Start date Start date
E

excel

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
 
Not without using a macro. And if the tab color changes the number will not
change.
_________________________________________________________________________
 
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
Click to expand...

can i perhaps execute the macro at any stage to reflect any change of
colour? and if so, what would be the macro?

TIA
Esra
 
An example

Public Sub TestTabColour()

With ActiveSheet
Select Case .Tab.ColorIndex
Case 10: .Range("A1").Value = 1
Case 3: .Range("A1").Value = 2
'etc
End Select
End With
End Sub


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top