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..