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
slaw