keno results import

[puroko]

I have been inputting keno results in excel spreadsheet from mylotto.co.nz website , everyday which is time consuming.

Question : Is there a way I can extract the keno results (1 to 80) from the above website directly into excel, so I could save time typing it in. ?


Next question is : If for example I want to monitor 7 number results : 21 24 25 29 41 43 44 every draw.

How do I make excel automatically colour those cells whenever any of the above numbers hit in the draw?

I wish to assign say yellow to 20 series and green to 40 series.

I attached a photo of the typed spreadsheet if there can be any help to improve the layout of labels in rows and columns.

thanks
purokokeno excel spreadsheet.PNG

[BelaEva11]

Szia elkuldened nekem az exel kenot
koszi

[BelaEva11]

Szia listat megkaphatnam koszi

[alansidman]

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread