Searching for data in an array.
 

Sounds simple, but I don't think it is.

Here is what I face:
Date Location
5/14/2009 A
5/14/2009 B
5/14/2009 B
5/14/2009 C
5/15/2009 A
5/15/2009 A
5/15/2009 B
5/15/2009 C

Based on today's date (Say 5/15/09) I want to highlight the cells that have
the same location. But only for today's date. When the date changes, they
are no longer highlighted and it moves on to a new day. Now I am working in
Excel 2003.
Can I get some hints or a clue here?

Thanks.

Searching for data in an array.
 

What you're looking for Conditional Formatting. Easier for you to do a quick
search of it in Excel's help than for me to explain it here. Basically,
you'll tell each of your cells to change their format if their value matches
the key value in another cell (e.g. where you're putting the date they need
to match).

"Tom" wrote:

Sounds simple, but I don't think it is.

Here is what I face:
Date Location
5/14/2009 A
5/14/2009 B
5/14/2009 B
5/14/2009 C
5/15/2009 A
5/15/2009 A
5/15/2009 B
5/15/2009 C

Based on today's date (Say 5/15/09) I want to highlight the cells that have
the same location. But only for today's date. When the date changes, they
are no longer highlighted and it moves on to a new day. Now I am working in
Excel 2003.
Can I get some hints or a clue here?

Thanks.

Searching for data in an array.
 

try conditional format

Select the column B as shown in your example
Go to Format on the Tool bar
Select Conditional Format
Under Contional 1, choose Formula Is
on the next box, type =A2=Today()
Click Format
Go to Patterns
Select the color
Click okok


--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"Tom" wrote:

Sounds simple, but I don't think it is.

Here is what I face:
Date Location
5/14/2009 A
5/14/2009 B
5/14/2009 B
5/14/2009 C
5/15/2009 A
5/15/2009 A
5/15/2009 B
5/15/2009 C

Based on today's date (Say 5/15/09) I want to highlight the cells that have
the same location. But only for today's date. When the date changes, they
are no longer highlighted and it moves on to a new day. Now I am working in
Excel 2003.
Can I get some hints or a clue here?

Thanks.

Searching for data in an array.
 

Hi Tom,

Try a conditional Format:

Select cell B2
Select the Format option from the main menu
Select Conditional Formating
Select Formula is in the first text box
In the second text box type the following formula: =and(a2=today(),b2=b1)
Click the Format button
Select whatever formats you wish to apply to the cell
Press the OK button twice.

This will not highlight both duplicates but one of them.

Please press YES if this helped

HTH
John

"Tom" wrote:

Sounds simple, but I don't think it is.

Here is what I face:
Date Location
5/14/2009 A
5/14/2009 B
5/14/2009 B
5/14/2009 C
5/15/2009 A
5/15/2009 A
5/15/2009 B
5/15/2009 C

Based on today's date (Say 5/15/09) I want to highlight the cells that have
the same location. But only for today's date. When the date changes, they
are no longer highlighted and it moves on to a new day. Now I am working in
Excel 2003.
Can I get some hints or a clue here?

Thanks.

Searching for data in an array.
 

Can anyone tell me how to do this with TEXT...that is text that is close but
not a perfect match? For example f I see MR and MR. I want them to be called
a match, even tho one does not ahve the period (or extra spaces or Jr, etc).
Having lots of trouble with this.

Searching for data in an array.
 

I don't think that there's a good way to do this.

I do my best to clean the data. I'd replace "MR " (with the space) with "Mr. ".

It's a lot of work and you'll always find more stuff to fix.

Good luck.

lkl wrote:

Can anyone tell me how to do this with TEXT...that is text that is close but
not a perfect match? For example f I see MR and MR. I want them to be called
a match, even tho one does not ahve the period (or extra spaces or Jr, etc).
Having lots of trouble with this.

--

Dave Peterson