Tab Color Changes depending on value of a cell
 

Is there a way to automatically change the tab color depending on the value
of a cell

Tab Color Changes depending on value of a cell
 

You gave NO detail but this will change tab color to number entered in cell
d1.
Right click sheet tabview codeinsert this

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$D$1" Then Exit Sub
Me.Tab.ColorIndex = Target
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Thiago" wrote in message
...
Is there a way to automatically change the tab color depending on the
value
of a cell