Conditional Formatting

  • Thread starter Thread starter BW
  • Start date Start date
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
 
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.
Click to expand...

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


Regards
Claus Busch
 
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,

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
 
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
Click to expand...

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!
 
Back
Top