How do I make a cell change to a certain colour, without affecting the
number that is already in it? I run a lottery Syndicate using a simple
workbook with 2 sheets in it. The first sheet keeps a historic record of
each weeks numbers as I key them in. The second sheet has all twenty members
number choices listed in a table. If I key in the weeks numbers on sheet
one, who do I get the winning cells on the next sheet to change to say,
yellow?

What I have to do now is manually check each line which is a pain,

Thanks