Compare & highlight data

Decreenisi

Guest

Posts: n/a

22nd Jun 2009

Hi,

I have data in column A1:A500 eg S13245, S37583, S98402,S27640 ect.
Then in column S1:S500 I will either manually enter or paste similar
data from another work sheet. Now here's the rub. I would like to
attach a macro to a button to search both columns & where the data in
A1:A500 is the same in S1:S500, I would like the cell (s) in A1:A500
to turn Yellow.

The reason is that I can quickly see the non yellow data in A1:A500
and know I have missing matches, which will help me understand reject
activity.

Can anyone suggest a macro ?

Thanks in advance

« Run Time Error '9':subscript out of range | Language independent formulas »

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

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Compare data in 2 workbooks and highlight differences in red	Sherry	Microsoft Excel Worksheet Functions	4	13th Jan 2009 12:20 AM
Compare and Highlight	SarahJ	Microsoft Excel Programming	1	11th Dec 2008 06:38 PM
Compare and highlight	Jamer	Microsoft Excel Programming	1	21st Aug 2008 06:21 PM
Compare Two Worksheets and Highlight Changes	TEAM	Microsoft Excel Programming	3	18th May 2006 01:17 PM
How do I compare 2 sets of data and highlight differences?	=?Utf-8?B?UGVycGxleGVkMQ==?=	Microsoft Excel Worksheet Functions	1	9th Jul 2005 01:15 AM