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 the numbers 1-59 and on the payment sheet I have everybody's numbers and payments. This is my issue.. Lets say that the draw for the first weeks bonus ball is number 1, I want to be able to highlight the number 1 on the DRAW page and it transfer the highlight to all the number 1's on the payment page in their chosen numbers on the right on their name. Then if the next draw number was a 20, I want to do the same, highlight the number on the draw page and it highlight those numbers on the payment page.. Is this possible or is there a better way to do this? thanks to anyone who can help me, I am quite new to excel so will need all the help I can get. Thanks again.
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.
- DRAW Page: In an empty cell (e.g., B1), enter the draw number.
- DRAW Page Formatting: Highlight the number range (e.g., A1), apply Conditional Formatting with the formula =$A1=$B$1.
- PAYMENT Page Formatting: Highlight the numbers, use Conditional Formatting with the formula =ISNUMBER(MATCH(B2, DRAW!$A$1:$A$59, 0)).
- Update B1 to see the highlighting change.
