Clake04Copper ContributorAug 21, 2022Highlight Similar matches in a different column Hi I am trying to figure out a formula that highlights when cell K does not match the monetary value in column L. Can anyone please assist? Show More
Harun24HRBronze ContributorAug 21, 2022Clake04 You can use below custom conditional formatting rule. See the sample attach file. =--LEFT($B2,SEARCH(" ",$B2))<>$A2 highlight_cells.xlsx10 KB
