Solved: Lottery Checker

[drums4monty]

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]

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]

Thanks p45cal, exactly what I wanted.