Conditional formating cells in a dynamic anual calendar

hi all,


i'm filling up the monthly sheets and the yearly calendar sheet is just an overview
i'm trying to mach the colors in the annual calendar with the ones in the corresponding month sheet.
the trickier part comes the moment you change year and the dates shift to the corresponding week days.

jan 01 2019 was on a Tuesday
jan 01 2020 - Wednesday
jan 01 2021 - Friday


edit
i've managed to get the colors to do this but just for individual cells

Try the following:
For Green: =INDEX(JANUARY!$H3:$H33,MATCH(B6,JANUARY!$A3:$A33,0))>=2/24
For Yellow: =AND(INDEX(JANUARY!$H3:$H33,MATCH(B6,JANUARY!$A3:$A33,0))>0,INDEX(JANUARY!$H3:$H33,MATCH(B6,JANUARY!$A3:$A33,0))<2/24)
For Red: B6<>""
Let us know if you have any questions.

Glad that you got a solution. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.