You should change the AVAIL sheet to not be coloured but to have a value saying say R(eserved), N(ot Available), or blank (Available), and use CF to colour based upon those values. Have a flat table of dates and values as well and then you could do a simple lookup based upon the dates being requested.
Bookmarks