Forum Discussion
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 ...
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.
Riny_van_EekelenThanks, I have not done any conditional formatting yet but will give it a shot. Thanks.
