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

In sheet $1$

The range of the calendar is B$6$:AF$29$

The cell of the list is AJ$14$

In sheet $2$

The table name is IQQ$\_121$

The range of the table is A$2$ to D$15$

Activity name in column $1$

Stuart's date in column $3$

The end date in column $4$

If there is any way to do it exactly without usin VBA will be better