Conditional Formatting

[BW]

Hi All,

I'm using Excel 2007, and am looking for a way to format the cells
color if it matches a range of other cells. What I'm working on is a
lottery sheet that allows me to enter the winning six numbers in six
seperate cells. Then below these six cells, there may be several sets
of six cells that I enter the ticket numbers in, and I would like to
have any cells that match the winning cells to turn yellow. Below is
my scenario.

The winning ticket numbers will be entered in cells: E1, F1, G1, H1,
I1, J1

Then the ticket numbers can be entered in any other cells, and when
any cell matches a number value listed in the above six cells, it
turns the cell yellow.

How can I automate this?

Thanks,
Brian

 

[Claus Busch]

Hi Brian,

Am Sat, 1 Oct 2011 09:31:24 -0700 (PDT) schrieb BW:

The winning ticket numbers will be entered in cells: E1, F1, G1, H1,
I1, J1

Then the ticket numbers can be entered in any other cells, and when
any cell matches a number value listed in the above six cells, it
turns the cell yellow.

your ticket numbers in E5:J10:
Select E5:J10 => CF => Formula:
=COUNTIF($E$1:$J$1,E5)>0


Regards
Claus Busch

 

[Jim Cone]

My free Excel add-in "Lottery Numbers" might help you determine which lottery numbers to play...
http://www.mediafire.com/PrimitiveSoftware
It can pick numbers for any of 12 state (USA) lotteries or for Mega Millions and Power Ball.
(no registration, no advertising, no personal information collected)
--
Jim Cone
Portland, Oregon USA .
http://www.mediafire.com/PrimitiveSoftware





"BW" <[email protected]>
wrote in message
news:9ee4930f-99b5-4394-a3ad-72fc49fa0822@m15g2000vbk.googlegroups.com...

 

[Gord]

Jim

I admire BW's optimism.

Not just "numbers" but "winning numbers"


Gord

 

[Jim Cone]

Gord,

Hope makes the world go around.
In all fairness, I think BW was referring to posting the winning numbers after the drawing.

There is one guy, posting in these newsgroups for at least ten years, that continues to ask
for help in generating groups of 5 to 6 random numbers and arranging them properly.
Now that is optimism.
'---
Jim Cone






"Gord" <[email protected]>
wrote in message

 

[Jim Cone]

Actually the free Lottery Numbers Excel add-in can be downloaded from...

http://excelusergroup.org/media/

Not the url I posted earlier.
---
Jim Cone



"Jim Cone"
<[email protected]>
wrote in message

My free Excel add-in "Lottery Numbers" might help you determine which lottery numbers to play...

 

[Gord]

On second reading.........I see what you mean.

Gord

 

[BW]

Gord, What Jim said.....

Brian

Jim

I admire BW's optimism.


Not just "numbers" but "winning numbers"

Gord

 

[GS]

There is one guy, posting in these newsgroups for at least ten years, that
continues to ask
for help in generating groups of 5 to 6 random numbers and arranging them
properly.
Now that is optimism.
'---
Jim Cone

Sounds like "Quick Picks" to me! Define "arranging them properly"!
Random numbers are generated based on Min/Max and so they return
arranged as randomly generated. Does this "guy" mean in sorted order
maybe?

Otherwise, Chip Pearson's 'UniqueRandomNumber' function is a great way
to generate 'Quick Picks' (in random order, of course<g>)! What's
really needed is a way to check random tickets against draw history so
you can evaluate the worth of the generated number combo on a number by
number basis for each prior set of winning numbers. Otherwise, why
generate your own ticket numbers when any lotto system will do that for
you? No point IMO if you can't determine a ticket's hit ratio against a
frequency table!