Please help, going mad over here
I've created a lottery bingo worksheet that highlights the numbers that have been drawn, the problem I'm having is highlighting the winner/winners once someone has all 6 numbers. I've got it working up to draw 10 (highlighted in blue) but after that it stops identifying (highlighting) the winner
The conditional format I'm using for turning the chosen numbers green is
=COUNTIF($Z$1:$AE$28,B1)>=1
=$B$1:$G$100,$R$1:$W$100,$J$1:$O$100
The format for identifying the winner once all there numbers have turned green is
=+(COUNTIF(WIN,B1)*COUNTIF(WIN,C1)*COUNTIF(WIN,D1)*COUNTIF(WIN,E1)*COUNTIF(WIN,F1)*COUNTIF(WIN,G1))>=1
=$A$1:$A$100,$I$1:$I$100,$Q$1:$Q$100
Can someone please tell me where its gone wrong
I've created a lottery bingo worksheet that highlights the numbers that have been drawn, the problem I'm having is highlighting the winner/winners once someone has all 6 numbers. I've got it working up to draw 10 (highlighted in blue) but after that it stops identifying (highlighting) the winner
The conditional format I'm using for turning the chosen numbers green is
=COUNTIF($Z$1:$AE$28,B1)>=1
=$B$1:$G$100,$R$1:$W$100,$J$1:$O$100
The format for identifying the winner once all there numbers have turned green is
=+(COUNTIF(WIN,B1)*COUNTIF(WIN,C1)*COUNTIF(WIN,D1)*COUNTIF(WIN,E1)*COUNTIF(WIN,F1)*COUNTIF(WIN,G1))>=1
=$A$1:$A$100,$I$1:$I$100,$Q$1:$Q$100
Can someone please tell me where its gone wrong
