Rules to be set on my team calender

hello my friends,

i face a problem last year on my team vacations, excuses and other related matters and for that i designed the attached calendar to focus on thier adherance and excuses issues.

Im doing many of manuall editing on this calendar such as highlight, add notes, add comments and others.

so what i would like to do is to insert my notes on another sheet (check the attached file on worksheet "sheet1") and to translate these notes directly to the calendar.

for example if my agent Manal going on leave for next month, i should add the dates (from & To) and this should be automaticlly highligh the general calendar with.

so please i need some guidnes on doing this as i thinked too much and comes with nothing

your support is really appreciated.

thanks & best regards,

hello again,

is there anyone can help me on that as i am still stock on it and i searched everywere and didn't find a solution.

i really appreciate your support guys on this matter.

BR,