Highlight Similar matches in a different column

Question

Hi&nbsp;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?&nbsp;&nbsp;

riny_van_eekelen · Answer

Clake04&nbsp;This could work, provided that the column A contains numbers formatted as currency and column B always starts with one currency symbol.Please see the attached file for a working example.

harun24hr · Answer

Clake04&nbsp;You can use below custom conditional formatting rule. See the sample attach file.&nbsp;=--LEFT($B2,SEARCH(" ",$B2))&lt;&gt;$A2&nbsp;&nbsp;&nbsp;&nbsp;

Forum Discussion

Highlight Similar matches in a different column

2 Replies