Hello all,

I am using using excel to track assets. I have two columns titled Description and Serial Number. I wish to only highlight duplicate serial numbers where the Description is the same. At present I am using CF to highlight duplicate serial numbers using =COUNTIF($B$2:$B$11,B2)>1. This highlights all duplicate serial numbers but I wish to refine it only to show duplicates against its description.

Thanks