Conditional formatting of worksheet tabs

Greetings all,

I've searched the forums for an answer and found a thread from 2015 but the suggestion posted isn't working on my sheet (or I'm not applying it properly).

I have a cell in my worksheet ($J$12) that is conditionally formatted to change color depending on its value (progressive 5-color scale from green to red).
I'd like the worksheet tab to be conditionally formatted to whatever color that cell is shaded.

This will apply to multiple worksheets in the workbook.

I'm pretty good with general excel programming but once we get into VBA code I'm at a loss. I'm assuming VBA coding is required here.

Does anyone have a link to a thread that advises in understandable language how to do this?

Thank you

Hi there,

Try inserting the following code in the VBA CodeModule of the worksheet which contains your Cell $J$12 (i.e. not in a standard module):

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

Oh sweet!!
Never mind, apparently it didn't work until I switched sheets and went back, now it's working.

Is there a way to set it to default color (gray) when the cell value is null? Currently the tabs are white (due to background color). What would the code look like to say if cell has value then interior color, otherwise default color?

Hi again,

Try:

Please Login or Register  to view this content.

Hope this helps.

Regards,

Greg M

Got an error.

SS3.PNG
SS4.PNG

Reply from my phone.

Of course you got an error - there's no such thing as Cell *H12*

Regards,

Greg M