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?