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