Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I make tab colors dependant on cell entries?
I'm using a spreadsheet with multiple tabs. I'd like to have the tabs all
red until the appropriate fields have been filled in on the sheet. Once this is accomplished I'd like to have the tabs turn green. Is this possible? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I make tab colors dependant on cell entries?
Make all the tabs red manually.
Put this in worksheet code: Private Sub Worksheet_Change(ByVal Target As Range) If Range("A1").Value = "" Or Range("A2").Value = "" Then Exit Sub End If ActiveWorkbook.ActiveSheet.Tab.ColorIndex = 4 End Sub In this example, once BOTH A1 and A2 have been filled in the tabe turns green. -- Gary''s Student gsnu200704 "Thomas" wrote: I'm using a spreadsheet with multiple tabs. I'd like to have the tabs all red until the appropriate fields have been filled in on the sheet. Once this is accomplished I'd like to have the tabs turn green. Is this possible? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I make tab colors dependant on cell entries?
Thank you for responding so quickly... but I must confess, I'm rather green
at excel at this point, not complete novice, but you lost me at put this in worksheet code. LOL Where on the worksheet do I enter it? Do I need a certain syntax when I type it in? Do I have to type it in for each active sheet, or can I copy and past it into the sheets (I have 46 active sheets in the workbook). Thanks again! Thomas "Thomas" wrote: I'm using a spreadsheet with multiple tabs. I'd like to have the tabs all red until the appropriate fields have been filled in on the sheet. Once this is accomplished I'd like to have the tabs turn green. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependant drop-down lists allowing invalid entries | Excel Discussion (Misc queries) | |||
What do I need to add to my macro to make the cell colors change | Excel Discussion (Misc queries) | |||
Cell Colors Dependant on Date | Excel Programming | |||
make cell entries a negative number | New Users to Excel | |||
Name worksheets dependant on Cell entries | Excel Programming |