As a beginner with Excel and VBA I have the following problem. I do kee
track of lottery numbers in a sheet.

Don't ask me why. It doesn't help me win a big price. There is a dra
of six numbers every week, from 1 to 45. I

keep them in six collumns. From the year 1996 to this week. I'd like t
seek combinations of numbers, say 2 or 3

numbers. If I, for example seek 3 numbers, 4-5-12 then they should sho
up highlighted or coloured or whatever,

if they excist in that combination. Or else give a statement that th
combination doesn't excist.
I have tried something with conditional formating but I can't seem t
get that to do what I want. Is there

anybody who can give me a hint!!

--
Message posted from http://www.ExcelForum.com