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:

Conditional formatting formula:

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

Related posts:

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

Highlight duplicates where an adjacent column is in a date interval using conditional formatting in excel

Highlight duplicates using conditional formatting in excel

Highlight the second or more duplicates in two lists using conditional formatting in excel

Create a list of duplicates where adjacent cell value meets a condition in excel