[Solved] Highlight duplicate values in excel

Try conditionally formatting A2:A12 with the following formula:

=IF(ISERROR(SEARCH("*"&$A2&"*", $A$1)>0), FALSE, TRUE) (see screenshots below).