Change tab color based on cell values across worksheets

[OCP]

This is my first post to this forum. I hope I have all in order…<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Excel version is 2003. Win XP Pro…<o></o>
<o> </o>
I have a workbook in which I want to change tab colors based on cell values. All of the input cells are on the worksheet called “CustInfo.”<o></o>
<o> </o>
There are 3 cells that have values that – depending on the value or text – will change the tab color of 3 OTHER worksheets.<o></o>
<o> </o>
These cells on the CustInfo worksheet are:<o></o>
E6 with range name “ans_csr”<o></o>
E7 with range name “ans_lefv”<o></o>
E8 with range name “ans_locations”<o></o>
(Whether range names or just the cells are used doesn’t matter…)<o></o>
<o> </o>
So,<o></o>
<o> </o>
If CustInfo E6 (ans_csr) text value is “Y” the tab on sheet “LOA-S” is green (14), otherwise default gray.<o></o>
If CustInfo E7 (ans_lefv) text value is “Y” the tab on sheet “LEFV” is green (14), otherwise default gray.<o></o>
If CustInfo E8 (ans_locations) numerical value is >1 the tab on sheet “MLSO” is green (14), otherwise default gray.<o></o>
<o> </o>
I have done a great deal of searching to find the solution to this, but nothing quite meets my need. I have managed the tab color change, but the difficulty is getting the change to me more or less and on/off switch, based on the cell inputs.<o></o>
<o> </o>
Any help would be greatly appreciated!<o></o>

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=560697

Please be careful not to post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: http://www.mrexcel.com/forum/showthread.php?t=99490).