Hi all. For my next bit of my project, for each ball I would like to list the dates that they were drawn. There will be two lists, one for main draw and one for bonus draw - taken from 'Draws' tab, columns C, D:I and J.
I have created a third sheet, and manually put in the first few results. But there are over 2500 draws, each with seven balls! And the list gets longer each week. I'm not sure how possible this will be - I am beginning to think that I have created something of a monster
As the icing on the cake, I would like to apply a conditional format to the results to differentiate between Saturday and Wednesday draws e.g. Blue text for Saturdays, red for Wednesdays.
If someone could get me started on ball number 1, I'd be happy to duplicate it for the remaining 58 balls. I have a lot of time while we are in national lockdown!
As ever, all help greatly appreciated.
Bookmarks