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