Map of Rooms
I have 330 rooms, each have a number and status (ie reserved, vacant,occupied, etc). I want to create a layout showing all these rooms (each as a square) and each room will have a different colour based on its status. I can change the status using conditional formatting but my problem is to update each individual square based on room number. All my rooms (square) show the status of the current record only, how can I walk all records and update each and every square?