Shading of cells with lots of different criteria to follow

[Yan Ni]

I need help in the shading of the cells according to the criteria I set.

There are 3 criteria that the shading must follow :
1. Arrival Date and Time
2. Departure Date and Time
3. Plane Mark start and end

I would need to do it in such a way where, when I enter information into the table which is located at the right hand side of the spreadsheet, that i will shade the all the cells which is the dates range between the arrival and departure date and time( including both the arrival date and departure date itself), but it can also shade the areas where of the plane mark from the start and end.
In the end the cells shaded should form a box or rectangle shape where only those where only areas where this 3 criteria are met, are shaded.

Appreciate if someone could help me to solve this problem!!!