trying to color tabs based on conditions

[MissZigster]

Hi. I am trying to figure out a way to color tabs in a workbook template ("sample") based on cell values or the color of another corresponding tab.

For example:
a) if cell b5 is not zero, color the tab pink
or
b) if sheet3 is colored purple (tab), then color sheet7 pink

Any help would be greatly appreciated.

Thanks!

[p24leclerc]

You can try this macro that you will put into the section "ThisWorkbook" of the Visual Basic Editor.
Changing the active sheet color will not show until you select another sheet.
You can play with the codes to get what you want. It will be a little bit tricky.
I'm working with the colorindex as it is easier to handle but you have to check what colorindex is assigned to a tab before using its value in an IF statement.

Please Login or Register  to view this content.