Excel to create a 'lotto wizard'

[pmg]

I am trying to use excel to create some kind of 'lotto
wizard' where by:

I would list the selected numbers by the syndicate member
in rows(1 number per cell) and this information will
always be fixed.I would simply enter the numbers drawn in
the lotto in selected cells........ and would be able to
apply a formula to the cells containing the sysdicate
numbers which would automatically highlight a number if
it were drawn in the lotto.

Basically.. saving a lot of time manually checking the
numbers each week

Please help.

 

[PegL]

Assume you put the selected numbers in cells a1:f1 and
name the range Sel. Select the fixed numbers for all
members and go to Format; Conditional formatting. You can
use formula is: = not(isna(Hlookup(B6,Sel,1,false))). B6
is the 1st cell in the fixed numbers set. Change the
format to whatever you want to see.