Aug 21 2022 09:09 PM
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?
Aug 21 2022 09:21 PM
@Clake04 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.
Aug 21 2022 10:12 PM - edited Aug 21 2022 10:17 PM
@Clake04 You can use below custom conditional formatting rule. See the sample attach file.
=--LEFT($B2,SEARCH(" ",$B2))<>$A2