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

Totally Amazing. Thank you both very much indeed. I appreciate the guru precious time you have both taken to help me. If that sounds too grateful it's because I am.

Pete_UK
The seat numbering with the row number included is a brill idea. The noobs might lose a few brain cells. I can already picture trying to convince a couple of airheads that it's a great idea. The formula works perfectly so I'll do a refresher with COUNTIF.

protonLeah
Again the formula works perfectly. Thanks for doing the seat numbering to show the conditional formatting example fully. It will really help.

I'm going to try both of these methods over the next day or so and let you know how it goes. Hope you don't mind if I pop back to ask any questions if my brain cells start frying as well.

Thanks again.

I think the important thing with the seat numbering is that each seat number must be unique - you could just have a sequential number from 1 to 500 (or whatever), or you could have a row letter with a number, or row number with a number (as in my example). Set this up in your seating plan, and then make sure the ticket numbers reflect your seat numbers (and the entries in Seats columns also follow the same scheme).

Feel free to post back with any future problems. You might want to mark this thread as Solved (the FAQ describes how), and then any future questions could be in a new thread.

Hope this helps.

Pete