Forum Discussion

SeaStar91's avatar
SeaStar91
Copper Contributor
Feb 14, 2023

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...
excel
dscheikey's avatar
dscheikey
Bronze Contributor
Feb 14, 2023

SeaStar91 

Here is my solution:

Conditional Formarting:

 

=AND(B1=XLOOKUP("*",B1:B1000,B1:B1000,FALSE,2,-1),ROW()<>XLOOKUP("*",B1:B1000,ROW(B1:B1000),FALSE,2,-1),B1<>"")

Only the duplicates of the last entry are marked.

See if that fits.

 

Resources