Excel L Lotto numbers

Dolby

Honorary Master
Joined
Jan 31, 2005
Messages
39,162
Reaction score
6,146
Or maybe a simple program to do this?

Basically every now and again I buy 20 lotto numbers. Is it possible to have those 20 lotto numbers in an Excel sheet, and when they announce the numbers, simply enter them so the program compares?

It's a pain going through all of them
 
i used to have an excel file that did this for me.

I had the list of lotto numbers in the left hand side of the file, and then the weeks lotto numbers on the right hand side, and all i did was use Conditional formatting to check each cell if it was equal to the lotto numbers and if so then hightlight red.
Rather simple. Start with one line first off all and then just copy it downwards with the conditional formatting be copied as well.
 
Top
Sign up to the MyBroadband newsletter
X