Lotto Number Checker

clash Wrote:
> 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.



Thanks for all your help !!

this is going to save alot of time.

Clash.


--
clash

Perhaps you could use Conditional Formatting?
For a six number lottery, put the winning numbers into B1:G1.
Then, Select the cell range where the numbers on your tickets are entered.
Go to Format | Conditional Format and change the Condition drop-down to
Formula is. Enter this formula:
=OR(B9=$B$1,B9=$C$1,B9=$D$1,B9=$E$1,B9=$F$1,B9=$G$1)
Then, set your formatting. When a number in the grid matches a winning
number, it will change formatting to match what you set.

--
tj


"clash" wrote:

>
> clash Wrote:
> > 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.
>
>
>
> Thanks for all your help !!
>
> this is going to save alot of time.
>
> Clash.
>
>
> --
> clash
>

Contact me I will send you excel file, which I created for my self
[email protected]slaw