Lotto Bingo

Hi, new user here.

This question has probably been asked a million times before but here goes.

I'm looking to run a weekly lotto bingo to help raise funds for my kids football team.

I have created the attached sheet, but i would like it when i type in the numbers from the draw that the highlight in yellow it beside the persons name.

eg. As the weeks go on and more numbers are drawn, more of the players numbers are highlighted in yellow until someone has all 6 numbers highlighted and therefore win the pot.

Is this possible?

File attached (i think!)

Thanks in advance.

Superb John, really appreciate that. I'm a total Newby at this