maybe I didn't make it clear, sorry but it goes like this.

a 3 4 9 28 36 39 21/04/2012 4 15 25 28 35 49
b 1 12 25 28 39 49 28/04/2012 12 13 36 37 41 46
c 3 4 8 14 39 49 05/05/2012


where column A is the name, a,b,c,d,etc. B to G the chosen Numbers. Column J
the date of draw. K to P the drawn numbers. hope this makes more sense.

thanks


John
"jkf" wrote in message
...
sorry that was does not seem to work

"jkf" wrote in message
...
no unless iam doing something wrong it does seem to work, thanks for your
input

john

"zvkmpw" wrote in message
news:32263615.1835.1334962552345.JavaMail.geo-discussion-forums@pbcuv5...
... 25 people pick 6 numbers
1-49 (yes its based on the UK lottery) so she has a grid made out to
suit
this i.e. Adam 1 5 9 10 25 49

down 25 names and numbers

then another grid made of
21.04.12 1 8 11 25 28 48

is there a way of as when you insert the Lottery numbers that the
corresponding number picked changes colour.

This worked for me with Excel 2003.

I have the names in a column starting in A1, and the first grid of
numbers in B1:G25.

I have the lottery numbers to be matched starting in K1 and extending to
the right.

I selected B1:G25 and used this conditional formatting equation:
=COUNTIF($K$1:$AZ$1,B1)0

Hope this helps getting started.