Lotto question

B

Bojames

I am trying to setup something using excel for my company lotto pics. We play
30 plays (6 numbers a play) and I need a way to highlight the common (winning
numbers) against the numbers drawn. Any thoughts would be appreciated.
 
T

T. Valko

So, you have 30 rows by 6 columns?

Assume A1:F1 is where you enter the numbers that are drawn.

A3:F32 are the numbers you've played

Select the range A3:F32
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:

=AND(A3<>"",OR(A3=$A$1:$F$1))

Click the Format button
Select the Patterns tab
Select a color (GREEN sounds good)
OK out
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to create a 'lotto wizard' 1
reading blank cell as active - how can I stop it ? 1
How do I compare a list of Lotto winning numbers to my ticket? 4
Calculate the Number of Subsets 10
Query assistance 1
conditional formatting 7
lotto numbers 2
Problem with In(SELECT...) 5

Top