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.

Conditional formatting or Vlookup?
 

Conditional formatting could do this for you.

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

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

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


HTH,
JP


On Jan 21, 8:02*am, pa_broon74 wrote:
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.

Conditional formatting or Vlookup?
 

Thank you.

That worked perfectly.

Paul.

Conditional formatting or Vlookup?
 

You're welcome!

--JP

On Jan 21, 11:39*am, pa_broon74 wrote:
Thank you.

That worked perfectly.

Paul.