If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is their a limit to the number of auto text entries | annie | General Discussions | 1 | February 28th, 2005 04:42 AM |
Number of objects | thomak | General Discussion | 3 | February 17th, 2005 11:58 AM |
Lotto Number Array | Chambersteacher | Worksheet Functions | 2 | February 1st, 2005 08:41 AM |
Maximum number of pages in a word document | Travis75 | Formatting Long Documents | 5 | January 27th, 2005 05:03 AM |
Setting A Number Equal to Another Number | slag018 | General Discussion | 1 | October 19th, 2004 04:16 AM |