Hi guys,
I'm sure this is pretty basic question, but I seem to be struggling to make it work.
I have my work schedule which automatically populates and changes the cell colour if I am working on a particular date.
I would like to have a list of dates for my leave outside the calendar and the colour changes if that day is in the list of dates.
Screenshot attached shows January next year. I am due to be working 8th to 11th January as it is green. The list at the side is the days leave I wish to take, if the date of the cells are in that list I would like it to change colour to red not green.
Thanks.
I'm sure this is pretty basic question, but I seem to be struggling to make it work.
I have my work schedule which automatically populates and changes the cell colour if I am working on a particular date.
I would like to have a list of dates for my leave outside the calendar and the colour changes if that day is in the list of dates.
Screenshot attached shows January next year. I am due to be working 8th to 11th January as it is green. The list at the side is the days leave I wish to take, if the date of the cells are in that list I would like it to change colour to red not green.
Thanks.