Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
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
2 Answers
- expletive_xomLv 71 decade agoFavorite Answer
you are trying to highlight the cells that match?
and data validation worked? but that wouldnt highlight. are you describing what you need correctly?
you just wouldnt use data validation...you want to use conditional formatting
open a new sheet
- A1 to F1 has the numbers drawn
- A2 to F2 has your My numbers
- select A2 to F2 (or whatever cells you will need down the column A2:F6)
- click the conditional formatting button
- click new rule
- click use a formula to determine
- copy&paste this formula in the formula box
=IF(OR($A$1=A2,$B$1=A2, $C$1=A2,$D$1=A2,$E$1=A2, $F$1=A2),1,0)
- click format... and choose a color you want to highlight your cells
- click ok
tha should work. if you change the My Numbers, and they match the numbers drawn, then you get your highlight.
edit-
ok, that makes sense.
this should just work
if its not working for any reason, feel free to email me.
