Conditional Formatting

B

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
 
C

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
 
J

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...
 
J

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
 
G

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top