Pick five numbers

[ewhite]

I have a worksheet that has all the numbers that I picked for the pick 5 lottery, listed from B24:N71. These are 5 different numbers. What I want to do is highlight the cells that equal the 5 numbers that were drawn, which I have located at S5,T5,U5,V5,W5

[shg]

Select B24:N71, Format > Conditional Formatting > Formula is: =ISNUMBER(MATCH(B24, $S$5:$W$5, 0)), and then set highlight formatting as you wish.

[JBeaucaire]

Here's a sample LOTTERY sheet I've worked up. Look at the CONDITIONAL FORMATTING for the cells in the main pool of numbers.

It's the same approach. Use a conditional format to highlight the cell if it matches your range.

Highlight all the cells in B24:N71
Click FORMAT > CONDITIONAL FORMATTING
Condition1: Formula Is: =MATCH(B24,$S$5:$W$5,0)
Set your format pattern color.

[ewhite]

Thanks for the help. I didn't put a space between the comma and 0, and I couldn't get it to work. After I put the space in, it was ok. Now I have another problem. I want to check to see that when I get 2 picks of the 5, it will place a $1.00 after the Win in column I and S. When I get 3 of 5 to place a $10.00, and when I get a 4 0f 5 to place a $300.00. And when I get 5 of 5 to place a Jackpot.

[daddylonglegs]

Try this formula in I24 copied down

=LOOKUP(SUMPRODUCT(COUNTIF(S$3:W$3,B24:F24)),{0,2,3,4,5;"",1,10,300,"Jackpot"})

format as currency and copy down. Amend for column S

[ewhite]

Thanks for the info, but instead of getting 1,10,300,jackpot I get 2,3,4. Could you please help me.

Earl

[shg]

It works fine for me exactly as written when copied to H24 and then down.

[ewhite]

I entered the formula just as listed, and still get the numbers 0,2,3,4,5 and not $1.00 for 2 hits,$10.00 for 3 hits, $300 for 4 hits, "Jackpot for 5 hits.


Earl

[shg]

See attached.

[butlej6]

hello,
How you you add more than one row of winning numbers?
I would like to enter the winning numbers every week as I'm playing a much larger game.

Thankyou in advance.

[teylyn]

please don't hijack another poster's thread. You can start a new thread and if you want, refer to this one for background info.

[butlej6]

sorry i wasnt aware of this.....I'm afraid I'm noob