Random cell selct/highlighting

[kiboodez]

Hi all,

I was wondering if someone could help me with, probably a very simple, problem.
I have classroom seating plans set out with names in cells to represent desks, and am looking for some way to automatically highlight one of the names at random (completely randomises who I direct questioning to). I can do this easily as a list, but want it to actually highlight the person in the seating position, not just the name. I have attached a file showing how I’ve done it as a list (sheet 1) and an example of my seating plan on (sheet 2).