| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change tab colour when using conditional formatting in a cell
how can I change a tab to colour to highlight a problem without going into an
actual worksheet to work on |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change tab colour when using conditional formatting in a cell
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 |
|
#3
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 |
|
#4
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change tab colour when using conditional formatting in a cell
If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started". http://www.mvps.org/dmcritchie/excel/getstarted.htm In the meantime.......... First...create a backup copy of your original workbook. To create a General Module, hit ALT + F11 to open the Visual Basic Editor. Hit CRTL + R to open Project Explorer. Find your workbook/project and select it. Right-click and InsertModule. Paste the code in there. Save the workbook and hit ALT + Q to return to your workbook. Run the macro by going to ToolMacroMacros. You can also assign this macro to a button or a shortcut key combo. Gord Dibben MS Excel MVP On Mon, 23 Oct 2006 12:04:02 -0700, julie s wrote: "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 Gord Dibben MS Excel MVP |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change tab colour when using conditional formatting in a cell
Hit ALT+ F11 and cop and paste Gord's code into the white space on the right
hand side of the window that appears. Hit save and close out of that window. Now, if A1 contains something other than "Hello" you will see the tab color for that sheet1 change. Change the cell and sheet reference as appropriate for your sitatuation. Dave -- Brevity is the soul of wit. "julie s" wrote: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
change tab colour when using conditional formatting in a cell
thank you I will try and let you know how I get on
"Dave F" wrote: Hit ALT+ F11 and cop and paste Gord's code into the white space on the right hand side of the window that appears. Hit save and close out of that window. Now, if A1 contains something other than "Hello" you will see the tab color for that sheet1 change. Change the cell and sheet reference as appropriate for your sitatuation. Dave -- Brevity is the soul of wit. "julie s" wrote: 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 |
| Reply |
| 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 | |||
Linear Mode
