I will try my best to explain the situation :
I have a sheet where we enter test data and serial numbers.
Column Ais serial number
Column Cis if the unit passed or not.
I currently have conditionalformatting to highlight duplicate serial numbers (based on
Because we fix and
retest failed units we get duplicates of serial numbers where one has
column C and the other has
What I would like to do is :
Have the sheet find duplicates but only highlight when both duplicates have "pass" in