Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bingo Ball
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with VBA | Excel Discussion (Misc queries) | |||
Bingo | Excel Discussion (Misc queries) | |||
Bingo Lottery Winning Numbers | Excel Discussion (Misc queries) | |||
Ezcel crystal ball | Setting up and Configuration of Excel | |||
Create random number bingo cards with Excel | New Users to Excel |