View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pa_broon74 pa_broon74 is offline
external usenet poster
 
Posts: 12
Default Conditional formatting or Vlookup?

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.