that is great but how do i do that???

"Gord Dibben" wrote:

You cannot use CF to change a Tab color.

You would need VBA.

Either event code or just a macro.

Sub test()
If Sheets("Sheet2").Range("A1").Value < "hello" Then
Sheets("Sheet1").Tab.ColorIndex = 6
Else
Sheets("Sheet1").Tab.ColorIndex = -4142
End If
End Sub


Gord Dibben MS Excel MVP

On Mon, 23 Oct 2006 11:27:02 -0700, julie s <julie
wrote:

how can I change a tab to colour to highlight a problem without going into an
actual worksheet to work on