I have a Worksheet with 2 Tabs. Tab 1 = Planner, Tab 2 = Source Data.
Tab1 - Planner, Names and dates of the month
<tbody>
</tbody>
Tab2 - Source Data, Names, Visit Label, Start Date, End Date <-dynamic data pulled from CRM.
<tbody>
</tbody>
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?
Tab1 - Planner, Names and dates of the month
1/6/18 | 2/6/18 | 3/6/18 | 4/6/18 | 5/6/18 | 6/6/18 | 7/6/18 | 8/6/18 | 9/6/18 | |
Person1 | |||||||||
Person2 | |||||||||
Person3 | |||||||||
Person4 |
<tbody>
</tbody>
Tab2 - Source Data, Names, Visit Label, Start Date, End Date <-dynamic data pulled from CRM.
Staff | Name | Start Date | End Date | Status |
Person1 | Label1 | 1/6/18 | 2/6/18 | Open |
Person2 | Label2 | 4/6/18 | 7/6/18 | Open |
Person3 | Label3 | 2/6/18 | 9/6/18 | Open |
Person4 | Label4 | 8/6/18 | 9/6/18 | Scheduled |
<tbody>
</tbody>
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?