Hello all!

It's my first request on the forum, hope you'll understand it and can eventually help me!

We're gonna setup an internal "Loto" system with some friends, and therefore I wanted to create a simple excel sheet that will help us to find out who's gonna win.

Here's already a preview of what it looks like :

Cond.Format..xlsx

Now, every week we will input the bonus number of the loto in the excel sheet (under W 01, W 02 etc.)

Under this line there's a table with the numbers each person chose, and the first one who has all numbers right wins the kitty.

Now, what I would like todo, to make this easier, and more visible, is simply adapt a Conditional Formatting to the "person's number" table and if a number is equal to one of the above week numbers it becomes green.

When I try " equal to " + " =$B$2:$CY:$2 " it says that I cannot use the conditional formatting for a range... .

Any ideas?

Thanks in advance!