I need to highlight the duplicate values from a cell to a list in excel.Here is the input cell(In One cell)1A - London,Perth,DublinList to compare2A Paris3A London4A New York5A Dublin6A Perth7A Washington8A Mumbai9A Monacco10A Dublin11A Shanghai12A LondonI need to highlight the duplicate values. Eg. London, Perth and Dublin Should get Highlighted(Dublin & London appears twice so it should be highlighted twice) 解决方案 Try conditionally formatting A2:A12 with the following formula:=IF(ISERROR(SEARCH("*"&$A2&"*", $A$1)>0), FALSE, TRUE) (see screenshots below). 这篇关于在Excel中突出显示重复的值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!
08-03 23:38
查看更多