Excel Lotto Checker

Select cell A1 then select FORMAT|CONDITIONAL FORMATTING from the menu bar select "Formula Is" and use the following

=COUNTIF($A$15:$F$15,A1)>0

Where $A$15:$F$15 is the range where you place the actual numbers called for the week change that to whatever range you wish to use. Now select the PATTERN color you want to use for Hilighting if the number is one that was called. once you have that set then you can copy the format from a1 across to F1 usind EDIT | Paste Special | Formats then copy the first row and do the same thing down as many rows as you want to keep track of tickets.

Hope that makes since for you.

If you want the formula to indicate the number of winning numbers by row,
you can use one of the following:

=SUMPRODUCT(COUNTIF($A$15:$G$15,A2:G2))

or Array enter with Ctrl-Shift-Enter one of

=SUM(IF(TRANSPOSE($A$15:$F$15)=A2:F2,1,0))

=SUM(IF(COUNTIF($A$15:$G$15,A2:G2)=1,1,0))

Edit ranges as necessary


Additional comments:
- if you want to highlight results with winners say matches of 3 or more, apply conditional formatting.
- you can extend each of the formulas to consider 'bonus' numbers; you can have one result with bonus number and one without
- countif will give total of winning tickets

Found your query when I was searching site for something else. Did you have any luck with your lotto checker. If it is of any interest or help to you I do one. Look at my website www.jjnixon.btinternet.co.uk. If it helps you can have it.
John