Help With Formula

[MickB]

Hi,

On Sheet 1 under Column B, I have a list part numbers that are defective.
On Sheets 2, 3, 4, 5 etc...... under Column O, I have blank cells to enter part numbers - if a number is entered into any cell under Column O that matches any of the defective part numbers in Sheet 1 Column B I would like the adjacent cell in Column P to fill red (as a warning flag).

What formula would work?

Thanks Mick

 

[Fluff]

Have a look here

Conditional Formatting From Different Sheet - Contextures Blog

A nice new feature in Excel 2010 is the ability to refer to a different worksheet when creating conditional formatting and data validation. Let's take a look

contexturesblog.com

and scroll down to "Conditional Formatting Workaround for Earlier Versions"