The conditional formatting currently just greys the two corresponding hotel rooms. I would like it to grey, lock the cell (so no one can make a reservation for those rooms when the 2 bedroom is reserved, or add data into those cells), and if possible when you select the greyed cells it would pop up a message saying "the 2 bedroom is reserved, this will cause double booking" or something like that.