Forum Discussion
derek jordan
Feb 06, 2020Copper Contributor
Bonus Ball Spreadsheet
Hi all, I need help with my spreadsheet (attached). I am running a lottery bonus ball competition in work and we are working on both draws Saturday and Wednesday. On the DRAW page I have ...
Riny_van_Eekelen
Feb 06, 2020Platinum Contributor
Rather than trying to match a highlight in one sheet with another, why not list your drawn numbers in one column and use conditional formatting in the Payment sheet to highlight the numbers drawn. I've attached an example in the attached workbook for range AB10:AG28. Obviously, you would want to change the reference to another column for every periodic sheet.
- derek jordanFeb 06, 2020Copper Contributor
Riny_van_EekelenThanks, I have not done any conditional formatting yet but will give it a shot. Thanks.