Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tab color change
I have a workbook with several sheets inside of it. I would like for the tab
color to automatically change color is a condition is met. For example if on the sheet a cell has a drop down list and by choosing one of the selections from the drop down menu would automatically change the color of the tab for that sheet to red for example. If this is possible can you set different colors for the drop down list? If you choose one selection it turns green another selection yellow, etc.. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tab color change
You would need to do this in VBA, and then only in a version of XL that
supports colored tabs. XL 2000 and earlier do not support colored tabs. See here for more info: http://www.mvps.org/dmcritchie/excel/colors.htm Scroll to the section "Changing the Colors of Worksheet Tabs" about 4/5 of the way down. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "cac1966" wrote: I have a workbook with several sheets inside of it. I would like for the tab color to automatically change color is a condition is met. For example if on the sheet a cell has a drop down list and by choosing one of the selections from the drop down menu would automatically change the color of the tab for that sheet to red for example. If this is possible can you set different colors for the drop down list? If you choose one selection it turns green another selection yellow, etc.. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tab color change
I read this section maybe I didnt fully understand it. It told me how to
change the colors of the tabs but I didnt see anything mentioned about automatically changing color of tabs if a condition was met in a worksheet. Any comments would be appreciated. "Dave F" wrote: You would need to do this in VBA, and then only in a version of XL that supports colored tabs. XL 2000 and earlier do not support colored tabs. See here for more info: http://www.mvps.org/dmcritchie/excel/colors.htm Scroll to the section "Changing the Colors of Worksheet Tabs" about 4/5 of the way down. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "cac1966" wrote: I have a workbook with several sheets inside of it. I would like for the tab color to automatically change color is a condition is met. For example if on the sheet a cell has a drop down list and by choosing one of the selections from the drop down menu would automatically change the color of the tab for that sheet to red for example. If this is possible can you set different colors for the drop down list? If you choose one selection it turns green another selection yellow, etc.. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tab color change
Well, a quick google search turns up this:
http://groups.google.com/group/micro...c3563fab3fc197 Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "cac1966" wrote: I read this section maybe I didnt fully understand it. It told me how to change the colors of the tabs but I didnt see anything mentioned about automatically changing color of tabs if a condition was met in a worksheet. Any comments would be appreciated. "Dave F" wrote: You would need to do this in VBA, and then only in a version of XL that supports colored tabs. XL 2000 and earlier do not support colored tabs. See here for more info: http://www.mvps.org/dmcritchie/excel/colors.htm Scroll to the section "Changing the Colors of Worksheet Tabs" about 4/5 of the way down. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "cac1966" wrote: I have a workbook with several sheets inside of it. I would like for the tab color to automatically change color is a condition is met. For example if on the sheet a cell has a drop down list and by choosing one of the selections from the drop down menu would automatically change the color of the tab for that sheet to red for example. If this is possible can you set different colors for the drop down list? If you choose one selection it turns green another selection yellow, etc.. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
tab color change
Thanks Dave!
"Dave F" wrote: Well, a quick google search turns up this: http://groups.google.com/group/micro...c3563fab3fc197 Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "cac1966" wrote: I read this section maybe I didnt fully understand it. It told me how to change the colors of the tabs but I didnt see anything mentioned about automatically changing color of tabs if a condition was met in a worksheet. Any comments would be appreciated. "Dave F" wrote: You would need to do this in VBA, and then only in a version of XL that supports colored tabs. XL 2000 and earlier do not support colored tabs. See here for more info: http://www.mvps.org/dmcritchie/excel/colors.htm Scroll to the section "Changing the Colors of Worksheet Tabs" about 4/5 of the way down. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "cac1966" wrote: I have a workbook with several sheets inside of it. I would like for the tab color to automatically change color is a condition is met. For example if on the sheet a cell has a drop down list and by choosing one of the selections from the drop down menu would automatically change the color of the tab for that sheet to red for example. If this is possible can you set different colors for the drop down list? If you choose one selection it turns green another selection yellow, etc.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
Allow users to change the color of the comment indicator color so. | Excel Discussion (Misc queries) |