Thread
:
Bingo Ball
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
Posts: n/a
Bingo Ball
Assuming that your numbers are in a grid in A1:F8 anfdthe bonus ball numbers
are entered along row 1 from H1, use the conditional formatting formula:
=LOOKUP(50,$A$1:$F$8)=A1
and copy the conditional format to all the other grid cells
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"Nomis-MCSE" wrote in message
...
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
Reply With Quote