Hi all,
Sheet2. I have a sheet with a row of names in row1 and under each name will dates of holidays booked by each name.
Sheet1. On another sheet is a calendar with the date of a month running along a row say from B1. Then in ColumnA from A2 I have the same list of names as on the other sheet. If the person's name in A2 has booked off the date as in B1, I would like the cell B2 to be formatted.
There may be occasions where names on sheet1 may have to be moved around and I would like the formatting to follow.
Any help would be greatly appreciated.
Sheet2. I have a sheet with a row of names in row1 and under each name will dates of holidays booked by each name.
Sheet1. On another sheet is a calendar with the date of a month running along a row say from B1. Then in ColumnA from A2 I have the same list of names as on the other sheet. If the person's name in A2 has booked off the date as in B1, I would like the cell B2 to be formatted.
There may be occasions where names on sheet1 may have to be moved around and I would like the formatting to follow.
Any help would be greatly appreciated.
Last edited:
