Reverse raffle help

**chapelhill** · 01-09-2011, 06:21 PM

I'm trying to create a spreadsheet to use with a projector for a fundraiser reverse raffle, sort of like a bingo flashboard. Ideally I'd like to have rows 2:19 with 25 numbers each, 1-450. Then when a number is drawn, I'll enter it into A1 and the corresponding cell below will change its background color. As the raffle continues it should be easy for the audience members to identify what tickets are still in the raffle.

I can't seem to figure out how to use conditional formatting that won't reset with each entry in A1. Any help is appreciated.

**teylyn** · 01-09-2011, 06:35 PM

Hello,

if you change the number in A1, then conditional formatting based on the value of A1 will change, of course. You need to store/duplicate the numbers drawn and put them in a list, adding each drawn number to that list. Then base the conditional formatting on whether or not the number exists in the list, for example with Match().

If you are not adverse to a macro, it would be easy to create one that adds any value entered in A1 to the bottom of a list automatically.

cheers

**teylyn** · 01-09-2011, 06:50 PM

See the attached macro-enabled file with a 10x10 grid. Enter a number into A1 and it will be appended to the list in column D. The conditional formatting rule is

=ISNUMBER(MATCH(F1,$D$2:$D$101,0))

The macro is

Please Login or Register  to view this content.

cheers

**glfngrl12** · 01-30-2017, 02:35 PM

Is it possible to make the macro mentioned above to run between two files. I would like to project my board in one file and enter the drawn numbers in another file. I do not want the running list taking up space on the screen. If there is a simpler way to only show the board on one screen I'm open to any additional methods as well. Thank you

**teylyn** · 01-30-2017, 08:12 PM

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.