Is there a way to automatically change the tab color depending on the value of a cell
T Thiago Sep 10, 2008 #1 Is there a way to automatically change the tab color depending on the value of a cell
D Don Guillett Sep 10, 2008 #2 You gave NO detail but this will change tab color to number entered in cell d1. Right click sheet tab>view code>insert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$D$1" Then Exit Sub Me.Tab.ColorIndex = Target End Sub
You gave NO detail but this will change tab color to number entered in cell d1. Right click sheet tab>view code>insert this Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address <> "$D$1" Then Exit Sub Me.Tab.ColorIndex = Target End Sub
