Reply to thread

Message: [QUOTE="Mark, post: 6795245"] Strange request, but here goes. At present I have an autoupdating seating plan for my classes. It consists of a list of students on one sheet and a "grid" showing the ddesks on another. Currently each "desk" contains a formulae similar to "=List!B1" So a colleague comes up with an idea to colour code her plan t gives students feedback on behaviour and progress. However if we do this the coloured allcated to each child will stay with the seat, losing the flexibility that "Sort data by" affords. So my question is ... Is it possible to allocate a colour to the "student" rather than the "desk" and have this ccolour move with them if the list is resorted? Thanks in advance [/QUOTE]