Bingo Lottery

hello one and all

Have a proble trying to remember the conditional format for sorsing the
numbers out for my works Bingo Lotto please read below to see how it works


40 people in lotto all have 6 numbers 1 to 49 ( ROWS B to G )as the bonus
ball is the only number to be used there is only one number per week ( Row I )

What i need is as the number is added every week it looks through all the
peoples numbers and marks the ones that have come up say make the area gray
by shading.

Regards

Nomis-MCSE

Format>Conditionnal formatting>Formula is:
=COUNTIF($I:$I,B2)>0

See example: http://cjoint.com/?gbtuSpIMRn

HTH
--
AP

"Nomis-MCSE" <NomisMCSE@discussions.microsoft.com> a écrit dans le message
de news: C898E3FC-1AB5-4ABD-BA4F-ED4CB17AF1C1@microsoft.com...
> hello one and all
>
> Have a proble trying to remember the conditional format for sorsing the
> numbers out for my works Bingo Lotto please read below to see how it works
>
>
> 40 people in lotto all have 6 numbers 1 to 49 ( ROWS B to G )as the bonus
> ball is the only number to be used there is only one number per week ( Row
> I )
>
> What i need is as the number is added every week it looks through all the
> peoples numbers and marks the ones that have come up say make the area
> gray
> by shading.
>
> Regards
>
> Nomis-MCSE