Colour Cells based on multiple criteria Date, Staff and Status.

[morjo21]

I have a Worksheet with 2 Tabs. Tab 1 = Planner, Tab 2 = Source Data.

Tab1 - Planner, Names and dates of the month
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]1/6/18[/TD]
[TD]2/6/18[/TD]
[TD]3/6/18[/TD]
[TD]4/6/18[/TD]
[TD]5/6/18[/TD]
[TD]6/6/18[/TD]
[TD]7/6/18[/TD]
[TD]8/6/18[/TD]
[TD]9/6/18[/TD]
[/TR]
[TR]
[TD]Person1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Person4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Tab2 - Source Data, Names, Visit Label, Start Date, End Date <-dynamic data pulled from CRM.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Staff[/TD]
[TD]Name[/TD]
[TD]Start Date[/TD]
[TD]End Date[/TD]
[TD]Status[/TD]
[/TR]
[TR]
[TD]Person1[/TD]
[TD]Label1[/TD]
[TD]1/6/18[/TD]
[TD]2/6/18[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]Person2[/TD]
[TD]Label2[/TD]
[TD]4/6/18[/TD]
[TD]7/6/18[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]Person3[/TD]
[TD]Label3[/TD]
[TD]2/6/18[/TD]
[TD]9/6/18[/TD]
[TD]Open[/TD]
[/TR]
[TR]
[TD]Person4[/TD]
[TD]Label4[/TD]
[TD]8/6/18[/TD]
[TD]9/6/18[/TD]
[TD]Scheduled[/TD]
[/TR]
</tbody>[/TABLE]

What I would like to do is Automatically fill the Cell Colour in the Planner based on the data from the Source tab. Bonus if a label can be added to the first cell.

Example:
When opening the spreadsheet it would fill Cells B2 and C2 in light green against Person 1 and add label "Label1" to the cell B2.
Cells I5 and J5 against Person4 will be Dark Green (because the status is different) with label "Lablel4"

Is this possible?