| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change tab colour when using conditional formatting in a cell
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change Colour on a Cell after another cell has been changed | Excel Discussion (Misc queries) | |||
| Conditional formatting similar to shading alternating rows | Excel Worksheet Functions | |||
| Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
| Conditional Formatting to Test Value in Cell | Excel Worksheet Functions | |||
| Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
Threaded Mode
