Auto color change to tabs in worksheet
 

Are there any functions that will change the tab color on the worksheet based
on specified criteria?

Hi .....,

In Excel 2002 and above you can color individual worksheet tabs.
Select the sheets you want to color by holding down the CTRL key and clicking the tabs.
Right-click the sheet tab and then click Tab Color.
Click the color you want, and click OK.

There are better alternative in my optinion than coloring sheet tabs.
Changing the Colors of Worksheet Tabs (#tabs)
Color Palette and the 56 Excel ColorIndex Colors
http://www.mvps.org/dmcritchie/excel/colors.htm#tabs
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"scaast" wrote in message ...
Are there any functions that will change the tab color on the worksheet based
on specified criteria?