Complicated Conditional Formatting across 2 sheets help required

Hello,

I'm trying to adapt a premade attendance tracker from Excel. I thought it would be the quickest way but I am struggling with the conditional formatting formula I need. I posted the spread sheet below. I did not make this spreadsheet. I would like to use the information from sheet "Employee Leave Tracker" to highlight the calendar dates on the "Calendar View" sheet. I'm struggling to figure out how capture all the information I need. I attempted some IFAND functions, and a VLOOKUP function but can't wrap my head around capturing all the data.



Example: 1st employee has a tardy listed on the "Employee Leave Tracker" sheet. I want that date to be highlighted a unique color vs. the other types of attendance options(leave early, absent, etc).

Any help would be greatly appreciated! I posted this on some other forums but haven't received any feedback.