Forum Discussion
How to Find and Highlight Exact Match in Column
I am tracking cars that park without permission in a private lot and need a way to identify and highlight the same license plate number (Column B data) for a quick comparison to determine if there i...
=IF(COUNTIF($B$2:B2,B2)>1,MATCH(B2,$B$2:B2,0)+1,"")This is the formula in cell C2 which returns the row of a previous entry.
=COUNTIF($B$2:$B$28,B2)>1This is the rule for conditional formatting.
=$B$2:$B$28The format is applied to this range in the example.
