conditional formatting
 

Is it possible to color code a tab in a workbook based on a condition?

conditional formatting
 

Rob

Not without code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"rob" wrote in message
...
Is it possible to color code a tab in a workbook based on a condition?

conditional formatting
 

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

"Nick Hodge" wrote:

Rob

Not without code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"rob" wrote in message
...
Is it possible to color code a tab in a workbook based on a condition?

conditional formatting
 

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
HIS


"rob" wrote in message
...
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

"Nick Hodge" wrote:

Rob

Not without code

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"rob" wrote in message
...
Is it possible to color code a tab in a workbook based on a condition?