Conditional Formatting

's Computer Specifications

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

's Computer Specifications

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

's Computer Specifications

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" <(E-Mail Removed)>
wrote in message
news:9ee4930f-99b5-4394-a3ad-(E-Mail Removed)...
> 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

's Computer Specifications

Jim

I admire BW's optimism.

>> lottery sheet that allows me to enter the winning six numbers in six
>> seperate cells.

Not just "numbers" but "winning numbers"

Gord

On Sat, 1 Oct 2011 11:35:39 -0700, "Jim Cone"
<(E-Mail Removed)> wrote:

>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" <(E-Mail Removed)>
>wrote in message
>news:9ee4930f-99b5-4394-a3ad-(E-Mail Removed)...
>> 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.

's Computer Specifications

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" <(E-Mail Removed)>
wrote in message
news:(E-Mail Removed)...
> Jim
>
> I admire BW's optimism.
>
>>> lottery sheet that allows me to enter the winning six numbers in six
>>> seperate cells.
>
> Not just "numbers" but "winning numbers"
>
>
> Gord
>
> On Sat, 1 Oct 2011 11:35:39 -0700, "Jim Cone"
> <(E-Mail Removed)> wrote:
>
>>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" <(E-Mail Removed)>
>>wrote in message
>>news:9ee4930f-99b5-4394-a3ad-(E-Mail Removed)...
>>> 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.

's Computer Specifications

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"
<(E-Mail Removed)>
wrote in message
news:j67mi3$u76$(E-Mail Removed)...
>
> My free Excel add-in "Lottery Numbers" might help you determine which lottery numbers to play...

> http://excelusergroup.org/media/ (edited)

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

's Computer Specifications

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

Gord

On Sat, 1 Oct 2011 16:03:55 -0700, "Jim Cone"
<(E-Mail Removed)> wrote:

>In all fairness, I think BW was referring to posting the winning numbers after the drawing.

's Computer Specifications

Gord, What Jim said.....

Brian

On Oct 1, 4:47*pm, Gord <phnor...@shaw.ca> wrote:
> Jim
>
> I admire BW's optimism.
>
> >> lottery sheet that allows me to enter the winning six numbers in six
> >> seperate cells.
>
> Not just "numbers" but "winning numbers"
>
> Gord
>
> On Sat, 1 Oct 2011 11:35:39 -0700, "Jim Cone"
>
> <james.cone...@comcast.netXxx> wrote:
> >My *free Excel add-in "Lottery Numbers" might help you determine whichlottery 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" <bwot...@gmail.com>
> >wrote in message
> >news:9ee4930f-99b5-4394-a3ad-(E-Mail Removed)....
> >> 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.

's Computer Specifications

on 10/1/2011, Jim Cone supposed :
> 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!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional Formatting of text effecting formatting of background	=?Utf-8?B?SEFI?=	Microsoft Access Reports	6	25th Mar 2008 06:23 PM
Protect Cell Formatting including Conditional Formatting	=?Utf-8?B?TWljayBKZW5uaW5ncw==?=	Microsoft Excel Misc	5	13th Nov 2007 05:32 PM
Conditional Formatting No Longer Conditional in 2007 Beta	=?Utf-8?B?Q2FjdHVhci1Oby1KdXRzdQ==?=	Microsoft Excel Crashes	0	17th Nov 2006 10:01 PM
How do I do a complex conditional in a conditional formatting formula	Ray Stevens	Microsoft Excel Discussion	7	12th Mar 2006 10:24 PM
Conditional Formatting that will display conditional data	=?Utf-8?B?QnJhaW5GYXJ0?=	Microsoft Excel Worksheet Functions	1	13th Sep 2005 05:45 PM