Solved Macro for Windows 7 excel - Find and highlight values

April 12, 2013 at 09:40:02
Specs: Windows 7
I have a table that I import as a csv file into excel. It has a column full of item numbers.
Could you send me a macro or function to search for a certain list of numbers (Say A12, 14, 14567, 14) AND HIGHLIGHT THEM RED IN THE COLUMN WHEN THE PROGRAM FINDS THEM.

I would need to update the list of numbers from time to time would this be an issue.

Thanks


See More: Macro for Windows 7 excel - Find and highlight values

Report •


#1
April 12, 2013 at 17:36:56
✔ Best Answer
Please do not post in all caps. All caps is the internet equivalent of yelling and no one likes to be yelled at.

If I understand your question correctly, try this:

Let's say you have 2 lists of data: A1:A8 and B1:B3. I am assuming that you want to highlight any value in A1:A8 that is also in B1:B3.

e.g.

	A	B
1	2	6
2	8	2
3	4	5
4	5	
5	6	
6	5	
7	3	
8	4	

Select A1:A8 and use Conditional Formatting with this Rule:

=MATCH(A1,$B$1:$B$3,0)

If you change the values in either list, the formatting will follow the changes.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
April 16, 2013 at 15:54:52
Thanks,
Sorry for the all caps.

I am creating an inventory sheet in excell.

I would like to create a macro button on first spreadsheet. When you click the button, it would would look for values in column A found in column B (which will be hidden).

Example:
Column A Column B
234 234
134 174
123 123
134 133

If the values are present or not present, a summary report would be generated in another sheet that would report the following:

Column A Column B
234 In Stock
134 Not in Stock
123 In Stock
134 Not in Stock
Could you help me create the macro button ?


Report •

#3
April 16, 2013 at 16:58:05
What does this have to with your request to highlight matching values in red?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
April 17, 2013 at 09:02:13
I tried out your solution and it works however the list in column A is too long to quickly see the highlighted values. Therefore, our needs have changed.
We need to be able to push a button and have the values in a report.

Report •

#5
April 17, 2013 at 09:39:21
Since your new question is not related to "highlighting matching values", please post your question in a new thread with a relevant Subject Line.

Thanks.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#6
April 17, 2013 at 13:25:32
thanks for the help!

Report •


Ask Question