Lofty,
Did you really mean the numbers are rows rather than columns?
Or should numbers be in columns with a row per name?

Anyway, for columns of lotto numbers (Col A is name, B to G are numbers):

For each column : Formula is: = Match(B1,Lotto,0) where "Lotto" is a named
range the 6 numbers for the draw. Set format as required.

Repeat for columns C to G i.e Match(C1,Lotto,0) etc

With names in column A set CF:

Formula is: =Sum(B1:G1)=Sum(Lotto) and format as required.

HTH


"Lofty" wrote:

I run a Pub Lotto using Excel as the spreadsheet. I have 90 rows with 7
columns. C1 is the name. C2-7 are the numbers chosen. Each week 6 numbers are
picked out. I want to highlight the numbers picked amongst the rows with red
and change the font to white. I do this by hand every week. When all 6
numbers are filled in a row I change the name to Green fill. I also have a
separate table (7x7) with 1-49 showing the numbers previously drawn which
also get filled in Red/white as they are drawn. The "this week's numbers" are
shown in a row of 6 cells. I want to automate the process using conditional
format. I get so far but it doesn't keep the formatting.
Help please!
Is it possible? or do I have to get someone to run a VB programme for me?