Conditional Formatting (Loto system)

[b3ns]

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!

[Fotis1991]

Hi

Highlight range B7:K16.

In Conditional Formatting rules put this.

=COUNTIF($B$2:$CY$2,B7)

Choose green color>>OK.



How can you use Conditional Formating.

--In Excel 2007 and 2010, Conditional Formatting is in the Styles group on the Home tab. In Excel 2003, Conditional Formatting is on the Format menu. See here how you can work using CF.

[b3ns]

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

cond.form.error.jpg

[Fotis1991]

I don't understand why you get that message.. See the example pls..

[b3ns]

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!

[Fotis1991]

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.

[b3ns]

Done!

And I Added you Reputation! :P

[b3ns]

Done!

And I Added you Reputation! :P

[Fotis1991]

........................