drums4monty
08-24-2009, 11:23 PM
Hi All
This may have been asked before but I cannot find it and I have tried to solve it my self but to no avail. Attached is a spreadsheet with my syndicates lotto numbers on, each row is a Saturday draw. Col B - G are the drawn numbers with Col I - CM the syndicates numbers. How do you get the syndicates numbers to change colour if they match a drawn number? I thought it may have been by using VLOOKUP or something like that but cannot work it out.
This may have been asked before but I cannot find it and I have tried to solve it my self but to no avail. Attached is a spreadsheet with my syndicates lotto numbers on, each row is a Saturday draw. Col B - G are the drawn numbers with Col I - CM the syndicates numbers. How do you get the syndicates numbers to change colour if they match a drawn number? I thought it may have been by using VLOOKUP or something like that but cannot work it out.