I have a project which is a dynamic calendar yearly and left side calendar I have a list of activities which I created from data visualisation and all of it in sheet $1$ and I have a table including names of activities and names of students and dates all it as headers all it in sheet $2$

So my questions is how to do when I just click on list and selecte one of activity then The calender is highlighted like red or green color based on the dates on the table in sheet $2$

For example, if the date of activity A on the table in sheet $2$ starts from $3$ Jan to $2$ Mar

Then I go to list from the sheet and I choose activity A$.$ Then the calendar is highlighted from $3$ Jan to $2$ Mar as red colour or any colour and change the highlights of dates on the calendar when I choose any activities on the list $.$

How can do it in Excel with using VBA

And fit all names and Range of my sheets

sheet$1$ the range $of$ calender $isB6toAF29$

cell $of$ list $isAJ14$

$in$ sheet $2$ the name $of$ table $isIQ-121$

the range $of$ table $A2to15D$

start date $isin$ column $3$

end date $ison$ column $4$

the name $of$ activists $ison$ coulmI'm $1$

$if$ can $doit$ without usinusing VBA $it$ will $be$ better