Finding matching serialnumbers

I have list of names and serialnumbers. Then I have another list of serialnumbers. How do I find the same serialnumbers from that other list?

I would like to excel to mark the found serialnumbers like change the font colour to red etc.

What I am trying to do is, I have list of pc´s that have been disposed and then I have active list of pc´s. I need to find a way to mark the pc´s from the active list, that are already disposed.

Can´t seem to get that attachment thing to work. I have tried with VLOOKUP, but it´s not working as it should be.

I have something like this:

Name serial
xxx 788jkkkj

Then I have list of serials on the other column, that I need to match on the other list and mark them red.

Here is the attachment

Originally Posted by FDibbins

Thanks for the file.

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =MATCH($B4,$J$4:$J$6,0)...format fill as required

That way I can only find that one serial, but I have 160 serials, I need to try and match those 160 serials to 100 serials. With =MATCH, how do use CF, so that it finds from the range of serials. Now it uses only B4 value. Not sure If it can be done with CF and MATCH?

Yes I tried and was only able to get that one identified

=MATCH (lookup_value, lookup_array, [match_type])

First I select the range, then I click CF and formula, but I am not able to define "lookup_value" to range, I can only put that one cell. It won´t work If I put "lookup_value" to B1:C4 example.