Lottery

[smason]

Hello

i want to create a spread where i input the 6 lottery number into say a1 b1
c1 etc
and have my list of lottery numbers (4 rows of numbers or more) highlight
red (or what ever colour)

any ideas

 

[Mike H]

Hi,

I think you need to explain a bit more. In most lotteries (I think) you only
pick 6 numbers. What do you want highlighting and where? How do we get to 4
rows of numbers or more from 6 numbers?

Mike

 

[smason]

yes sorry

say i have the lotto numbers for that weeks draw i.e.
a1 b1 c1 d1 e1 f1
1 4 23 44 6 12

and these are my numbers each week that i want to check (same columns)
1 5 30 45 30 22
4 9 44 15 48 10
etc

i want my numbers to go red if they correspond with the drawn number

hope this helps

 

[Mike H]

Hi,

Select the 6 columns and as many rows as you have lines (Mine start in A4 so
change to suit) and then

Format|Conditional format
Select formula is and enter the formula
=COUNTIF($A$1:$F$1,A4)>0
Pick a colour and OK.

Mike

 

[David Biddulph]

Format/ Conditional Formatting/ Formula Is/
=OR(A2=$A$1,A2=$B$1,A2=$C$1,A2=$D$1,A2=$E$1)

 

[smason]

briliant

can i calculate a 'red cell' to say i.e three cells =3

 

[Mike H]

Hi,

Counting the colours is possible but this is simpler. Put the formula at the
end of each row and drag down

=SUMPRODUCT(--ISNUMBER(MATCH(A4:F4,$A$1:$F$1,0)))

Mike

 

[smason]

agai brilliant thanks for all the advice

Hi,

Counting the colours is possible but this is simpler. Put the formula at the
end of each row and drag down

=SUMPRODUCT(--ISNUMBER(MATCH(A4:F4,$A$1:$F$1,0)))

Mike

 

[Mike H]

Glad I could help

agai brilliant thanks for all the advice

 

[Don Guillett]

Here is the way I did it when I played the Lotto where b5:f5 are the winners
and b6:f6 are your numbers.
Quit years ago. Suggest you do the same.

=IF(F6=0,"",SUMPRODUCT(COUNTIF(B6:F6,$B$5:$F$5)))
Then use conditional formatting cell value is between 4 & 6

 

[T. Valko]

A bit shorter:

=OR(A2=$A$1:$E$1)

 

[David Biddulph]

Thanks. I knew there must be an easier way!

 

[Rick Rothstein \(MVP - VB\)]

Here is the way I did it when I played the Lotto

...<snip>...
Quit years ago. Suggest you do the same.

ROTFLMAO

Rick

 

[Don Guillett]

Hellofawaytomakemoney