Lottery

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

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" wrote:

> 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

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" wrote:

> 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" wrote:
>
> > 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

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


"smason" wrote:

> 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" wrote:
>
> > 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" wrote:
> >
> > > 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

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

"smason" > wrote in message
...
> 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

briliant

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


"Mike H" wrote:

> 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
>
>
> "smason" wrote:
>
> > 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" wrote:
> >
> > > 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" wrote:
> > >
> > > > 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

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" wrote:

> briliant
>
> can i calculate a 'red cell' to say i.e three cells =3
>
>
> "Mike H" wrote:
>
> > 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
> >
> >
> > "smason" wrote:
> >
> > > 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" wrote:
> > >
> > > > 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" wrote:
> > > >
> > > > > 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

agai brilliant thanks for all the advice

"Mike H" wrote:

> 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" wrote:
>
> > briliant
> >
> > can i calculate a 'red cell' to say i.e three cells =3
> >
> >
> > "Mike H" wrote:
> >
> > > 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
> > >
> > >
> > > "smason" wrote:
> > >
> > > > 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" wrote:
> > > >
> > > > > 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" wrote:
> > > > >
> > > > > > 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

Glad I could help

"smason" wrote:

> agai brilliant thanks for all the advice
>
> "Mike H" wrote:
>
> > 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" wrote:
> >
> > > briliant
> > >
> > > can i calculate a 'red cell' to say i.e three cells =3
> > >
> > >
> > > "Mike H" wrote:
> > >
> > > > 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
> > > >
> > > >
> > > > "smason" wrote:
> > > >
> > > > > 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" wrote:
> > > > >
> > > > > > 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" wrote:
> > > > > >
> > > > > > > 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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"smason" > wrote in message
...
> 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