Hi all,
I'm working on a sheet that is basically for accommodation room allocation. Simply put, I want a room present on the table to colour the corresponding room in the diagram RED. ie, the RED room is booked.
The sheet has about 3 or so different buildings on the sheet, say 111, 222 and 333, each with 3 floors (Ground, Middle, Top), and each floor with about 20 rooms.
I have 3 columns in the table (BLD, Floor, ROOM), so I have been trying to create a conditional formatting formula to check the table for the 3 criteria in the same row (eg. BLD 111, Ground, ROOM 15).
I've tried using IF(3 x MATCH formulas are on the same row), which works, but it will only find the first occurence of the BLD, not recurring ones.
So if the first booking is 111,GND,15, and the second is 111, GND, 16, the second formula won't work because the first occurence of 111 isn't on the same row as the "16".
I'm stumped at the moment and could really use some help.
Sample sheet can be provided, for some reason I can't upload it at the moment
THANK YOU!
I'm working on a sheet that is basically for accommodation room allocation. Simply put, I want a room present on the table to colour the corresponding room in the diagram RED. ie, the RED room is booked.
The sheet has about 3 or so different buildings on the sheet, say 111, 222 and 333, each with 3 floors (Ground, Middle, Top), and each floor with about 20 rooms.
I have 3 columns in the table (BLD, Floor, ROOM), so I have been trying to create a conditional formatting formula to check the table for the 3 criteria in the same row (eg. BLD 111, Ground, ROOM 15).
I've tried using IF(3 x MATCH formulas are on the same row), which works, but it will only find the first occurence of the BLD, not recurring ones.
So if the first booking is 111,GND,15, and the second is 111, GND, 16, the second formula won't work because the first occurence of 111 isn't on the same row as the "16".
I'm stumped at the moment and could really use some help.
Sample sheet can be provided, for some reason I can't upload it at the moment
THANK YOU!