PDA

View Full Version : Solved: Lottery Checker



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.

p45cal
08-25-2009, 12:09 AM
with conditional formatting; one way is to use the formula is option with (in cell I4 in this instance):
=NOT(ISNA(HLOOKUP(I4,$B4:$G4,1,FALSE)))
you can then copy the CF with the format painter to the rest.
This has been done in the attached.

drums4monty
08-25-2009, 10:34 PM
Thanks p45cal, exactly what I wanted.