Excel 07 find lottery numbers within a range?
I've created four rows of six numbers(one number per cell), which are each eligible for a sequence of draws
I have created six cells to enter the winning numbers from each draw. I would like to highlight My Numbers once the winning numbers entered. I've tried Data Validation; equal to.
It works as long as the numbers are in the same row or descending cells.
e.g.
7-15-19-26-35-41 Numbers Drawn
7-14-15-19-33-42 My Numbers
If you use Data Validation going down the only number it will match is "7"
The 15 & 19 will be not show.
From the Number Drawn cell, I've tried VLOOKUP, HLOOKUP, INDEX, MATCH, & INDEX(MATCH, but they only give you the intersecting cells within a Range. Just because I've tried the above commands, it doesn't mean I've used them correctly.
Any suggestions?
Yes, I'm trying to highlight the "My Numbers" when the Drawn Numbers are entered.
I made a mistake, I used Conditional Format - Highlight Cell Rules. Then clicked "Equals To". Did not enter a formula, selected the range down. Used the "Custom Format". Then formatted the font to bold.
Thank You, I'll try this tomorrow