Need formula to change Tab color based on Cell returned value

hello .. I need help, I need to have a tab or tabs color change when a value in a certain cell is a certain value.. 4 possible values, 4 different colors.

Im stumped.. But I know it can be done.. Soo I am consulting you experts out there!!

thanks in advance for your help.

the worksheet the value is on is "ScoreCard" and the cell that contains the formulated answer is cell "D19" and as of now the various tabs to turn colors should be referenced as sheet1,sheet2,sheet3,sheet4

etc..

thanks !!

you need to use VBA
based on your description i think this is what you want

hit Alt+F11 to open up the VBA window then on the left there should be a window with all of your open excel files, find yours and expand the microsioft excel objects if it's not already expanded
then double click on the sheet named ScoreCard
then in the code window that pops up there will be a pulldown menu that will say (general) change that to Worksheet and paste the code below

I chose random colors for the tabs you can change them by recording a macro and changing the colorindex = and tintandshade = to the values you chose

if the value is outside the tab color will be set to "none"

Please Login or Register  to view this content.