Highlight or colour a cell or cells based on cells in another range.

I am trying to do a seating plan and wonder if anyone can help with showing when a seat has been filled?

Guests Worksheet = Guests and the seat numbers they have been allocated.

Seating Worksheet = Numbered seating plan. (In the final version all of the seats will be numbered.

When seat numbers are entered into the "guest worksheet" how can the corresponding number in the "seating worksheet" be coloured e.g. when the number 16 is entered in the guest worksheet how can seat number 16 be turned into another colour to show that a seat has been allocated.

VBA code scares me and other newbies will be using the worksheet so can this be done with excel formulas?

Thank you.