Format/ Conditional Formatting/ Formula Is/
=OR(A2=$A$1,A2=$B$1,A2=$C$1,A2=$D$1,A2=$E$1)
--
David Biddulph

"smason" wrote in message
...
Hello

i want to create a spread where i input the 6 lottery number into say a1
b1
c1 etc
and have my list of lottery numbers (4 rows of numbers or more) highlight
red (or what ever colour)

any ideas