|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
change tab colour when using conditional formatting in a cell
"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
can you take me through this as I don't know how to
|