software

Hy all,

I'm a bit of a newbie to the more advanced stuff of excel. So bear with
me if I do not use the correct terms.

I'm making a lotto form for my family. And I want to fill in the
numbers that are drawn, and automaticly highlight those numbers in the
players number listing.

I wanted to accomplish that with conditional formatting, but The
formula was too long so it didn't work out the way I wanted.
Using the following formula :Code:
--------------------
IF(Stand.C5=Stand.$C$42;1;IF(Stand.C5=Stand.$D$42; 1;IF(Stand.C5=Stand.$E$42;1;IF(Stand.C5=Stand.$F$4 2;1;IF(Stand.C5=Stand.$G$42;1;IF(Stand.C5=Stand.$H $42;1;IF(Stand.C5=Stand.$C$43;1;IF(Stand.C5=Stand. $D$43;1;IF(Stand.C5=Stand.$E$43;1;IF(Stand.C5=Stan d.$F$43;1;IF(Stand.C5=Stand.$G$43;1;IF(Stand.C5=St and.$H$43;1;IF(Stand.C5=Stand.$C$44;1;IF(Stand.C5= Stand.$D$44;1;IF(Stand.C5=Stand.$E$44;1;IF(Stand.C 5=Stand.$F$44;1;IF(Stand.C5=Stand.$G$44;1;IF(Stand .C5=Stand.$H$44;1;IF(Stand.C5=Stand.$C$45;1;IF(Sta nd.C5=Stand.$D$45;1;IF(Stand.C5=Stand.$E$45;1;IF(S tand.C5=Stand.$F$45;1;IF(Stand.C5=Stand.$G$45;1;IF (Stand.C5=Stand.$H$45;1;IF(Stand.C5=Stand.$C$46;1; IF(Stand.C5=Stand.$D$46;1;IF(Stand.C5=Stand.$E$46; 1;IF(Stand.C5=Stand.$F$46;1;IF(Stand.C5=Stand.$G$4 6;1;IF(Stand.C5=Stand.$H$46;1;0))))))))))))))))))) )))))))))))........and so on....
--------------------I know that it probably is not the best way , and so it seems...the
formula was too long.

So what I want to do :
- make a list of players.
- Each player has chosen a list 10 numbers.
- I want to compare those numbers (with conditional formatting) with
a block of numbers.
- This block of numbers being 25 x 6 numbers (each week 6 numbers are
drawn, and I wanted to make room for 25 weeks) Every week I fill out
the form with 6 new numbers, and I want the numbers in the players
list to enlarge/change colour (with conditional formatting).The problem I'm facing is a clean way of comparing a cell to a block of
cells. The cell value should change colour/size if it matches any (or
more) of the numbers in the block....

Can anyone point me in the right direction ?

cheers
B4M--
B4MB4M
------------------------------------------------------------------------
B4MB4M's Profile: www.excelforum.com/member.php...oamp;userid=19846
View this thread: www.excelforum.com/showthread...hreadid=541956Hi!

I'm looking for a project. I'm bored!

Send me an email and I'll make one for you then you can study it to see how
it was done.

Here's my address:

xl can help at comcast period net

Remove quot;canquot; and change the obvious.

Biff

quot;B4MB4Mquot; gt; wrote in
message ...
gt;
gt; Hy all,
gt;
gt; I'm a bit of a newbie to the more advanced stuff of excel. So bear with
gt; me if I do not use the correct terms.
gt;
gt; I'm making a lotto form for my family. And I want to fill in the
gt; numbers that are drawn, and automaticly highlight those numbers in the
gt; players number listing.
gt;
gt; I wanted to accomplish that with conditional formatting, but The
gt; formula was too long so it didn't work out the way I wanted.
gt; Using the following formula :
gt;
gt;
gt; Code:
gt; --------------------
gt;
gt; IF(Stand.C5=Stand.$C$42;1;IF(Stand.C5=Stand.$D$42; 1;IF(Stand.C5=Stand.$E$42;1;IF(Stand.C5=Stand.$F$4 2;1;IF(Stand.C5=Stand.$G$42;1;IF(Stand.C5=Stand.$H $42;1;IF(Stand.C5=Stand.$C$43;1;IF(Stand.C5=Stand. $D$43;1;IF(Stand.C5=Stand.$E$43;1;IF(Stand.C5=Stan d.$F$43;1;IF(Stand.C5=Stand.$G$43;1;IF(Stand.C5=St and.$H$43;1;IF(Stand.C5=Stand.$C$44;1;IF(Stand.C5= Stand.$D$44;1;IF(Stand.C5=Stand.$E$44;1;IF(Stand.C 5=Stand.$F$44;1;IF(Stand.C5=Stand.$G$44;1;IF(Stand .C5=Stand.$H$44;1;IF(Stand.C5=Stand.$C$45;1;IF(Sta nd.C5=Stand.$D$45;1;IF(Stand.C5=Stand.$E$45;1;IF(S tand.C5=Stand.$F$45;1;IF(Stand.C5=Stand.$G$45;1;IF (Stand.C5=Stand.$H$45;1;IF(Stand.C5=Stand.$C$46;1; IF(Stand.C5=Stand.$D$46;1;IF(Stand.C5=Stand.$E$46; 1;IF(Stand.C5=Stand.$F$46;1;IF(Stand.C5=Stand.$G$4 6;1;IF(Stand.C5=Stand.$H$46;1;0))))))))))))))))))) )))))))))))........and
gt; so on....
gt; --------------------
gt;
gt;
gt; I know that it probably is not the best way , and so it seems...the
gt; formula was too long.
gt;
gt; So what I want to do :
gt; - make a list of players.
gt; - Each player has chosen a list 10 numbers.
gt; - I want to compare those numbers (with conditional formatting) with
gt; a block of numbers.
gt; - This block of numbers being 25 x 6 numbers (each week 6 numbers are
gt; drawn, and I wanted to make room for 25 weeks) Every week I fill out
gt; the form with 6 new numbers, and I want the numbers in the players
gt; list to enlarge/change colour (with conditional formatting).
gt;
gt;
gt; The problem I'm facing is a clean way of comparing a cell to a block of
gt; cells. The cell value should change colour/size if it matches any (or
gt; more) of the numbers in the block....
gt;
gt; Can anyone point me in the right direction ?
gt;
gt; cheers
gt; B4M
gt;
gt;
gt; --
gt; B4MB4M
gt; ------------------------------------------------------------------------
gt; B4MB4M's Profile:
gt; www.excelforum.com/member.php...oamp;userid=19846
gt; View this thread: www.excelforum.com/showthread...hreadid=541956
gt;
P.S.

OR....

Send me the file you currently have and I'll fix it.

Biff

quot;Biffquot; gt; wrote in message
...
gt; Hi!
gt;
gt; I'm looking for a project. I'm bored!
gt;
gt; Send me an email and I'll make one for you then you can study it to see
gt; how it was done.
gt;
gt; Here's my address:
gt;
gt; xl can help at comcast period net
gt;
gt; Remove quot;canquot; and change the obvious.
gt;
gt; Biff
gt;
gt; quot;B4MB4Mquot; gt; wrote in
gt; message ...
gt;gt;
gt;gt; Hy all,
gt;gt;
gt;gt; I'm a bit of a newbie to the more advanced stuff of excel. So bear with
gt;gt; me if I do not use the correct terms.
gt;gt;
gt;gt; I'm making a lotto form for my family. And I want to fill in the
gt;gt; numbers that are drawn, and automaticly highlight those numbers in the
gt;gt; players number listing.
gt;gt;
gt;gt; I wanted to accomplish that with conditional formatting, but The
gt;gt; formula was too long so it didn't work out the way I wanted.
gt;gt; Using the following formula :
gt;gt;
gt;gt;
gt;gt; Code:
gt;gt; --------------------
gt;gt;
gt;gt; IF(Stand.C5=Stand.$C$42;1;IF(Stand.C5=Stand.$D$42; 1;IF(Stand.C5=Stand.$E$42;1;IF(Stand.C5=Stand.$F$4 2;1;IF(Stand.C5=Stand.$G$42;1;IF(Stand.C5=Stand.$H $42;1;IF(Stand.C5=Stand.$C$43;1;IF(Stand.C5=Stand. $D$43;1;IF(Stand.C5=Stand.$E$43;1;IF(Stand.C5=Stan d.$F$43;1;IF(Stand.C5=Stand.$G$43;1;IF(Stand.C5=St and.$H$43;1;IF(Stand.C5=Stand.$C$44;1;IF(Stand.C5= Stand.$D$44;1;IF(Stand.C5=Stand.$E$44;1;IF(Stand.C 5=Stand.$F$44;1;IF(Stand.C5=Stand.$G$44;1;IF(Stand .C5=Stand.$H$44;1;IF(Stand.C5=Stand.$C$45;1;IF(Sta nd.C5=Stand.$D$45;1;IF(Stand.C5=Stand.$E$45;1;IF(S tand.C5=Stand.$F$45;1;IF(Stand.C5=Stand.$G$45;1;IF (Stand.C5=Stand.$H$45;1;IF(Stand.C5=Stand.$C$46;1; IF(Stand.C5=Stand.$D$46;1;IF(Stand.C5=Stand.$E$46; 1;IF(Stand.C5=Stand.$F$46;1;IF(Stand.C5=Stand.$G$4 6;1;IF(Stand.C5=Stand.$H$46;1;0))))))))))))))))))) )))))))))))........and
gt;gt; so on....
gt;gt; --------------------
gt;gt;
gt;gt;
gt;gt; I know that it probably is not the best way , and so it seems...the
gt;gt; formula was too long.
gt;gt;
gt;gt; So what I want to do :
gt;gt; - make a list of players.
gt;gt; - Each player has chosen a list 10 numbers.
gt;gt; - I want to compare those numbers (with conditional formatting) with
gt;gt; a block of numbers.
gt;gt; - This block of numbers being 25 x 6 numbers (each week 6 numbers are
gt;gt; drawn, and I wanted to make room for 25 weeks) Every week I fill out
gt;gt; the form with 6 new numbers, and I want the numbers in the players
gt;gt; list to enlarge/change colour (with conditional formatting).
gt;gt;
gt;gt;
gt;gt; The problem I'm facing is a clean way of comparing a cell to a block of
gt;gt; cells. The cell value should change colour/size if it matches any (or
gt;gt; more) of the numbers in the block....
gt;gt;
gt;gt; Can anyone point me in the right direction ?
gt;gt;
gt;gt; cheers
gt;gt; B4M
gt;gt;
gt;gt;
gt;gt; --
gt;gt; B4MB4M
gt;gt; ------------------------------------------------------------------------
gt;gt; B4MB4M's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=19846
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=541956
gt;gt;
gt;
gt;

Thanx Biff for your offer,

What I made is in the Mail.
As I said I'm not an advanced user, so I usualy solve thing the hard
way...using stuff I know...thus making it much more difficult that it
actualy is.

Please put an explanation in the sheet... so I can see how it's done.

Thanx again
B4M--
B4MB4M
------------------------------------------------------------------------
B4MB4M's Profile: www.excelforum.com/member.php...oamp;userid=19846
View this thread: www.excelforum.com/showthread...hreadid=541956gt;Please put an explanation in the sheet... so I can see how it's done

Will do!

Biff

quot;B4MB4Mquot; gt; wrote in
message ...
gt;
gt; Thanx Biff for your offer,
gt;
gt; What I made is in the Mail.
gt; As I said I'm not an advanced user, so I usualy solve thing the hard
gt; way...using stuff I know...thus making it much more difficult that it
gt; actualy is.
gt;
gt; Please put an explanation in the sheet... so I can see how it's done.
gt;
gt; Thanx again
gt; B4M
gt;
gt;
gt; --
gt; B4MB4M
gt; ------------------------------------------------------------------------
gt; B4MB4M's Profile:
gt; www.excelforum.com/member.php...oamp;userid=19846
gt; View this thread: www.excelforum.com/showthread...hreadid=541956
gt;