Highlight Similar matches in a different column

Occasional Visitor



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?




2 Replies

@Clake04 This could work, provided that the column A contains numbers formatted as currency and column B always starts with one currency symbol.

Screenshot 2022-08-22 at 06.18.23.png

Please see the attached file for a working example.

@Clake04 You can use below custom conditional formatting rule. See the sample attach file.


=--LEFT($B2,SEARCH(" ",$B2))<>$A2