This is a follow on question from question 26937769.
Basically, I have a list of holidays (this list will change and is about 1000 holidays). The holidays are listed in one table with a start date, end date (if not only one day), destination and then a list of up to 30 people attending each holiday, with each name in a further column.
I need to take this raw data and display it one spreadsheet with the names of the people going on the holiday down the left hand side, the dates along the top, and the destination in the cell, ideally as a comment. Cells need to be blank if the person is not on holiday, coloured green if they are going on one holiday that day, and coloured red if they are shown on two or more holidays (scheduling clash).
Many of the hoildays are single days.
I need to be easily able to update the "at a glance" view.
I've attached a sample dataset and a sample "at a glance" view, with only the first date shown as an example.
Many thanks! ee-question.xls