Conditional formatting or Vlookup?

[pa_broon74]

Hey folks.

I have a wee query. I have a spread sheet with two columns of data
(they're item codes.) I need to somehow highlight the item code in one
column if it exists in the other.

Background: I have a list of items that have been purchased sorted by
the Purchase Order on which they appear, thats the first list. The
second list is items in a particular department. I need to highlight
the items on the PO list but only from that specific department,
(second list.)

Mmm, hope that makes sense...

Thanks in advance.

Paul.

 

[JP]

Conditional formatting could do this for you.

Let's say your data is in columns A1:B1000.

1. Highlight column B.
2. Click Format>Conditional Formatting
3. Formula Is> =COUNTIF($A$1:$A$1000,B1)>0
4. Click Format>choose your favorite color
5. Click OK twice.

Anything in column B that is found in column A will be highlighted.


HTH,
JP

 

[pa_broon74]

Thank you.

That worked perfectly.

Paul.

 

[JP]

You're welcome!

--JP