AnsweredAssumed Answered

Map of Rooms

Question asked by Catts on Feb 1, 2013
Latest reply on Feb 1, 2013 by philmodjunk

Title

Map of Rooms

Post

     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?

Outcomes