Hi all,
I have a simple problem (i haven't touched a macro for ages),
On a a tab, I have a list of codes,
on another tab another list of code (very long). I would like to
highlight the codes in the second tab that matches the 1st one.

Thanks a lot in advance for your help

On Jun 3, 12:42*pm, AlbatroZ wrote:
Hi all,
I have a simple problem (i haven't touched a macro for ages),
On a a tab, I have a list of codes,
on another tab another list of code (very long). I would like to
highlight the codes in the second tab that matches the 1st one.

Thanks a lot in advance for your help



Can somebody help?

PLease

Cheers

Hi Albatroz.

See Chip Pearson at:

Extracting Elements Common To Two Lists
http://www.cpearson.com/excel/ListFunctions.aspx





---
Regards.
Norman


"AlbatroZ" wrote in message
...
On Jun 3, 12:42 pm, AlbatroZ wrote:
Hi all,
I have a simple problem (i haven't touched a macro for ages),
On a a tab, I have a list of codes,
on another tab another list of code (very long). I would like to
highlight the codes in the second tab that matches the 1st one.

Thanks a lot in advance for your help



Can somebody help?

PLease

Cheers

Thanks a lot norman,
but I wanted to highlight the common numbers in the second list
instread of extracting them.
I think it is feasible by writting a macro, if somebody can help
Pleaaaaaaaaase


Cheers

thanks a lot Norman, but I really want to highlight the numbers in the
second list instead of extracting them.
I was thinking about using a macro.
if somebody can help, pleaaaaaaaaase

Dim LastRow As Long
Dim i As Long
Dim CheckSheet As Worksheet

Set CheckSheet = Worksheets("Sheet1")
With Worksheets("Sheet2")

LastRow = .Cells(.Rows.Count).End(xlUp).Row
For i = 1 To LastRow

.Cells(i, "A").Interior.Colorindex = xlColorindexNone
If Not IsError(Application.Match(.Cells(i, "A").Value,
CheckSheet.Columns(1),0))) then

.Cells(i, "A").Interior.Colorindex =38
End If
Next i
End With

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"AlbatroZ" wrote in message
...
thanks a lot Norman, but I really want to highlight the numbers in the
second list instead of extracting them.
I was thinking about using a macro.
if somebody can help, pleaaaaaaaaase

On Jun 3, 3:42 am, AlbatroZ wrote:
Hi all,
I have a simple problem (i haven't touched a macro for ages),
On a a tab, I have a list of codes,
on another tab another list of code (very long). I would like to
highlight the codes in the second tab that matches the 1st one.

Thanks a lot in advance for your help

Can be done simply using conditional formatting,
Copy all the cells that you want to check and open the Conditional
Formatting window.
Use the 'formula is' option and then type in =countif([range],
[criteria])=0 choose the formatting you want and click ok.

Should highlight all the duplicates...