identify & apply cond format to particular values in a l

[Kat81]

Hi guys,

hoping you can help me with this!

If I have a list of values (phone numbers) in column A and on a separate sheet (sheet 2) I have a list of phone numbers that I want to find and highlight the occurences of in the list on the first sheet (column A).

Is there a way that I can run a macro that will search the list on sheet 1 for the values contained in the list on sheet 2 and then apply conditional formatting to those values which occur on both sheets?

Any suggestions would be GREATLY appreciated! If I need to be more clear please let me know. It makes perfect sense to me but I am blonde. :wink:

Thanks!

Kat

 

[onlyadrafter]

Hello,

Why the need for VB, why not just use CONDITIONAL FORMATTING?

You will neeed to name the two columns, the use

=MATCH(A1,sheet1,0)

and format as required

where sheet1 is one of the named ranges, use the same formula for the second sheet, but using a different named range.

 

[Richard Schollar]

Hi Kat

Do you really need to use a macro? Using a simple formula such as:

=ISNUMBER(MATCH(Sheet1!A2,Sheet2!$A$2:$A$1000,0))

will return True/False depending on whether a match is found. You could then use Autofilter to filter out the False values to just leave you with the Trues ie the numbers that exist on both sheets.

Does this help?

Richard

 

[Kat81]

Thanks guys!!!

Both suggestions worked a treat!

Thanks so much for the prompt and very helpful responses!!!!

have a great weekend!!

Kat