Change tab color based on a cell color

[freeon]

I have a cell that changes from red to yellow based on other cells value. Is there a way to have the tab change color to match a certain cells color.

[judgeh59]

this will turn the tab to Red

Please Login or Register  to view this content.

you'll have to convert the 255 to the color of your cell...let me know if you need help with that...

[judgeh59]

Please Login or Register  to view this content.

this will determine the current color of a cell and then adjust the tab color....

[freeon]

It didn't work. I even tried opening a new workbook to make sure it wasn't formulas inside my current workbook that was affecting it. In the new workbook I right click the tab and clicked on view code then pasted what you said above. Highlighted cell A1 and tab color didn't change. Did I miss something.

[judgeh59]

yes....did you run the code after you changed the cell color?...did you change to a new worksheet because the color on an active sheet tab looks sort of white with red around the edges....if you want this to happen automatically you have to put in the worksheet area and use something like Worksheet.change (there is a list)....the OP was a little lacking on how you want this to work....

[freeon]

Let me try to explain it a bit better. I have a workbook with 6 worksheet. The first worksheet is called EQUIPMENT. In this sheet I have multiple rows with equipment names. Beside the equipment name I put the price. On the bottom of the column with the price I have the total price for all equipment combined. As long as there is 1 pieces of equipment that doesn't have a price the cell with the total is red. Once all equipment has a price the cell with the total turns yellow. I would like the tab to turn yellow automatically when the cell turns yellow. All the other worksheet functions similarly. This way no matter wath worksheet I'm on I know if I'm missing prices or if all are there. I hope this clarifies what I'm looking for.

[judgeh59]

for each of the worksheets you need to have this piece of code....it's clunky but it works....so, in the project explorer of the VBA editor you will see your worksheet names...double click on the worksheet and copy and paste into each worksheet....remember, you'll only see a small change in color on the bottom of the tab until you move off the tab...

Please Login or Register  to view this content.

[freeon]

I did as instructed above but now the tab is always white no matter the color of the cell. And yes i did move of the tab to make sure.