String Comparison

Hello,

I have a list of product part numbers that have been sold in A1:A6300.

I have a list of product part numbers that contain a certain feature listed in B1:B500

I want to Highlight all the product part numbers that have been sold if they match those that contain this certain feature.

Pretty much I just want to look at certain information about products I have sold that have this certain feature.

Use conditional formatting.

See here:
http://www.contextures.com/xlcondFormat01.html
http://www.google.com/search?source=...56l563l4.3l7l0

Originally Posted by Whizbang

Use conditional formatting.

See here:
http://www.contextures.com/xlcondFormat01.html
http://www.google.com/search?source=...56l563l4.3l7l0

Wouldn't that be a lot of work? I would have to check the 1st value vs 500 values, the 2nd vs 500, the 3rd vs 500 then all the way up to 6300. I guess I don't need to highlight it, I just want to make it so I can easily identify it. Like output a 1 or a 0 then conditional format that output.

If you post a sample workbook I can respond with an example of what I mean. Conditional Formatting is very versatile and useful.