Hi
I wanted to conditional format dates in calendar, based on Date of arrival/ appointment in another spread sheet.
Ideally would Like to format Date of starting & end of event in different colour & the continuum in a different colour. eg 2016 relates to Calendar2016
Currently using calendar from
https://www.vertex42.com/ExcelTempla...-calendar.html
(Using this Calendar as allows me to generate a new one every year)
Open to any suggestion for calendar or change data in spreadsheet
Many thanks
Bookmarks