Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Searching/Counting an array | Excel Discussion (Misc queries) | |||
Searching for a value in an Array | Excel Worksheet Functions | |||
Searching a limited amount of rows in a vertical array | Excel Discussion (Misc queries) | |||
searching in an array | Excel Discussion (Misc queries) | |||
Searching for a criteria in array of cells within an IF statement | Excel Worksheet Functions |