Office Lottery pool tracker

[benster]

I have office 2010.I want to setup a lottery office pool so i can track the numbers workers get once they come up.
first everyone picks 10 numbers.
the spreadsheet will look like this

all the possible numbers will be on the top in order
1 thru 50


jim 1 2 3 4 5 6 7 8 9 10
bill 1 4 5 6 7 8 9 10 11 12

all i want to do it tell excel to highlight all the numbers that come up under each worker and one have any idea conditional formatting only does 3

 

[Derek Brown]

Hello and welcome to The Board.
In this example, the names are in column A, starting in A2 and the numbers are in columns B to K. In my test I had four names so the numbers were in B2:K5.
The cells that you use for the 'numbers that come up' need to be given a "Name" (see Name Manager under the ulas TAB). In this example I used the name LNumbers.
Now select B2 to K5 (important; B2 must be the active cell in this example so select that first).
In Conditional Formatting (Formula Is) enter the following formula:
=MATCH(B2,LNumbers,0)>0
and then choose the required format.

 

[benster]

no help no idea what you are talking about but thanks for the reply