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