This blog article is one out of two articles on the same subject.
Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel
Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel part 2

Question:
I have a list of equipment numbers that need the duplicates in that column highlighted - comparing all values regardless of Work Type, but only highlighting Work Type = TC. What would the formula be?

Work Type Equip # Result
PM RLF00424 FALSE
PM RLF01755 TRUE
PM RLF01890 FALSE
PM RLF00537 TRUE
PM RLF01530 FALSE
TC RLF01755 TRUE
TC RLF00579 FALSE
TC RLF00876 FALSE
TC RLF00537 TRUE
TC RLF00520 FALSE

Answer:

Highlight-duplicates-where-adjacent-cell-value-meets-criteria-using-conditional-formatting-in-excel-part-2

Conditional formatting formula:

=(COUNTIF($B$2:$B$11,$B2)>1)*($A2="TC")

Download excel sample file for this tutorial.
Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel part 2.xls
(Excel 97-2003 Workbook *.xls)

Functions used in this article

COUNTIF(range,criteria)
Counts the number of cells within a range that meet the given condition