Bingo Lottery Conundrum

[LambChops]

At work we run a lottery bingo where 30 people pick 6 numbers from a total of 30 numbers, the easy bit is highlighting a persons number when one is drawn using conditional formatting but I need to highlight a person if they have absolutely no chance of winning the game due to other people waiting on a number they require, for example;

Person1 is waiting for numbers 1 & 2 to come up
Person2 is waiting for number 1 to come up
Person3 is waiting for number 2 to come up


It is impossible for person1 to win as no matter which number is drawn (1 or 2) someone else will win and in this case they stop paying into the current game and start paying into the next game.

It can also be impossible for person1 to win if others are waiting for more than 1 number: -

Person1 is waiting for numbers 1,2,3 & 4 to come up
Person2 is waiting for number 1 & 2 to come up
Person3 is waiting for number 3 & 4 to come up

So how can this be solved programmatically or via formulas?

Thanks

[Ron Coderre]

Welcome to the forum
This is a moderated forum so please take a moment to read the Forum Rules (at the link above).
You'll see that, while we prefer that you don't post the same question to multiple forums, we DO require that you provide links to those other forum posts so we can track progress on them...and stop working on your issue if it has been solved elsewhere. Besides, the same Excel talent frequents multiple forums so you don't really get any additional exposure.

I'll post the link for you...THIS time.
http://www.mrexcel.com/forum/excel-q...conundrum.html

[LambChops]

Consider myself severely reprimanded & I have sent myself to the naughty step to write a thousand lines as punishment along with a good thwacking from my grannies walking stick, only joking the walking stick will come out NEXT time...