Random selection of a data located in a column, by text color

[gmaz2]

I am wondering, in excel 2003 is it possible to randomly select two numbers from one column, say column b9:b45, that are random numbers, and selected by two different font colors. In other words: b9=1348, b10=1349, b11=1350, b12=1351, b13=1352, b14=1353.

Say we press a macro button, and in field B50 one radom black colored number is selected of a field of say 30 numbers that are all black in that column, and in b51, one red number is selected, in a field of 30 red numbers.

We want to used this macro to select winners simulating a raffle drawing.

Thanks for your insights

[JBeaucaire]

The colors are irrelevant. You can think of them as "black" and "red" ranges if you want, but don't mix that thinking up into your logic.

Just setup two sets of numbers and use a standard random "selector" formula. Like the attached sample.

[gmaz2]

Thank you very much, had to access add-ins in excel and set those fields within it to generate the number, but it worked. One particular note: our numeric data is listed in one Column only, so we can press F9 until we get a boy/girl number selected.

Take Care and thanks once again.

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED]

[gmaz2]

Before I close this, the way the spread sheet is developed, can a formula be made to pull the random number to a given field, the number selected say is
B12, in column C is a name typed in the field, then say at b70, the random number is pull into that field, and then the name found in c70 is inserted next to the random number?? this could denote the boy, then on the row below that, say B72, and C72, the same occur from the second random (F9) attempt>

ie

                       Column B            Column C 
 
Row 9                8                       John Doe 
 
Row 16              20                     Mary Smith 
 
 
Summary of Random Selection after entering F9 
 
Row 70              8                        John Does 
 
Row 72             20                       Mary Smith