Change tab color based on cell values across worksheets<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><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>
fficeffice" /><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>
