conditional formating

[AlbatroZ]

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

 

[AlbatroZ]

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

 

[Norman Jones]

Hi Albatroz.

See Chip Pearson at:

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





---
Regards.
Norman

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

 

[AlbatroZ]

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

 

[AlbatroZ]

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

 

[Bob Phillips]

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)

 

[CloudDoctor]

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...