With the selected ticket numbers in A1:F30 and the winning numbers in H1:M1
then highlight all selected ticket cells and use Conditional Formatting with
the formula:

=COUNTIF($H$1:$M$1,A1)0

To count the winning numbers enter:

=COUNTIF(A1:F1,$H$1)+COUNTIF(A1:F1,$I$1)+COUNTIF(A 1:F1,$J$1)+COUNTIF(A1:F1,$K$1)+COUNTIF(A1:F1,$L$1) +COUNTIF(A1:F1,$M$1)

in G1 and copy down.


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk


"clash" wrote in message
...

Please help.

I have to check 30 Lotto tickets ever week and have tried (and failed)
to come up with a way over putting all the selected tickets in a grid,
and having another grid with that weeks numbers in. Then finding a "IF"
statement to highlight each of the current weeks numbers on the first
grid, therefore showing how many numbers on each ticket.

Your help would be invaluable.


--
clash