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

A bit shorter:

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


--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

Thanks. I knew there must be an easier way! :-)
--
David Biddulph

"T. Valko" wrote in message
...
A bit shorter:

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


--
Biff
Microsoft Excel MVP


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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

Here is the way I did it when I played the Lotto
...<snip...
Quit years ago. Suggest you do the same.

ROTFLMAO

Rick

Hellofawaytomakemoney
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rick Rothstein (MVP - VB)" wrote in
message ...
Here is the way I did it when I played the Lotto
...<snip...
Quit years ago. Suggest you do the same.

ROTFLMAO

Rick