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