This should be easy, but need a bit more information as I don't know much
about lotteries.
Does the order of the numbers matter?
Does it matter in which columns the numbers are (there are 6 columns, but
you mention 3 numbers)?

RBS

"knoertje " wrote in message
...
As a beginner with Excel and VBA I have the following problem. I do keep
track of lottery numbers in a sheet.

Don't ask me why. It doesn't help me win a big price. There is a draw
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 to
seek combinations of numbers, say 2 or 3

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

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

anybody who can give me a hint!!!


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