I have an annual leave spreadsheet that i fill out... ie
05/01/2019 - 12/05/2019 (this is over 3 cells) and want to put it into a calendar. See image.
basically i want to use a conditional format that highlights the cell to show the annual leave.
what i have done so far is to split the dates (so in the above scenario it will show all dates between the dates supplied) and then the calendar part highlights those days
I know index match doesnt allow for multiple columns, but how can i address my situation. Need to convert Sect 1 to Section 3 (which is just the highlights) and at the moment, my isnumber/match is only one column.
wayne
Bookmarks