Excel calendar - auto populate task and conditional format

I am looking for a freelancer to create an Excel calendar that can auto populate tasks and apply conditional formatting. I have the calendar format I like and the activities in a data sheet under chicago requirements. I attached my calendar with some formula attempts. Basically, want it to copy task to corresponding date and color code. Would be great if dynamic and would change to the current year automatically, so can see the task that are years out. I like the year view that is in template, great for printing out, but open to others. The calendar should have the following specifications: - Calendar Type: Yearly - Task Categories: The calendar should include specific tasks organized by categories. Want to auto populate task that match calendar due date. (If same due date populate both (all) task with same date in calendar. - Conditional Formatting: The preferred method for conditional formatting is color-coding. I have column with colors. I really liked if the legends could populate in center top of cell, but I am fine if just color coded. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of formulas and functions. - Experience in creating dynamic calendars with auto-population features. - Familiarity with conditional formatting and color-coding techniques in Excel. - Attention to detail and ability to organize tasks into categories effectively. If you have the necessary skills and experience to create an Excel calendar with auto-population and conditional formatting, please apply for this project.