I have posted this in other group with no response

hi all

hope some one can help a work colleague has asked if it possible to have a
sheet for her charity work, it works like this, 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


the idea is to match your numbers to the lottery numbers, first to do so
wins like a game of Bingo. at the moment she is colour filling grid as each
number is drawn :
Adam 1 5 9 10 25 49


is there a way of as when you insert the Lottery numbers that the
corresponding number picked changes colour. I have tried to do so using
Conditional Formatting but keep getting errors. my knowledge is basic and
still learning.

any help on this issue would be appreciated and it is a worth while charity
plus you would really her out as she is very busy with her cause.

thanks in advance

john