Tab Color Change

Hello all and thank you in advance for your help...within my spreadsheet I have expiration dates and when the date is within 30 days of expiring the cell turns yellow, once the date passes it will turn red, and it turns green if I mark it complete.

What I’m trying to figure out is how to get the tab to change colors as the cells change color. So if any cell is “red” then the tab turns red, regardless if there are yellow or green. Any yellow and green with no red then the tab turns yellow. Lastly tabs turn green or stay no color if there is no red or yellow.

Let me know if I need to clarify

Thanks again

Hi & welcome to the board.
Can you please post the code that you are currently using.
When doing so please use code tags, the # icon in the reply window