R
rob
Is it possible to color code a tab in a workbook based on a condition?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Nick Hodge
Rob
Not without code
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
Not without code
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
R
rob
What do you mean by code? How do I do that? I want a worksheet to evaluate
a cell. If the cell is less than 120, then I want the tab to turn red.
Thanks,
rob
a cell. If the cell is less than 120, then I want the tab to turn red.
Thanks,
rob
N
Nick Hodge
Rob
Something like this in the worksheet_change() event
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1")) Is Nothing Then
If Target.Value = 120 Then
Me.Tab.Color = RGB(255, 0, 0)
Else
Me.Tab.Color = xlNone
End If
End If
End Sub
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]
Something like this in the worksheet_change() event
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Target, Range("A1")) Is Nothing Then
If Target.Value = 120 Then
Me.Tab.Color = RGB(255, 0, 0)
Else
Me.Tab.Color = xlNone
End If
End If
End Sub
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
[email protected]