Conditional Formatting (Loto system)

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!

Hi, thanks for you quick reply, but I got that error :

cond.form.error.jpg

Hmmm, no clue why it was not working, anyways I copied your formula and now it's ok... strange!

Thanks for the help!

Have a nice day!

Done!

And I Added you Reputation! :P

Done!

And I Added you Reputation! :P