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 by using MBA code