Highlight Similar matches in a different column

Copper Contributor

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?

 

Clake04_0-1661141289504.png

 

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

 

Harun24HR_0-1661145410273.png