conditional formatting formula that matches another cell exactly, but with a "1" on the end of the string...

[kbishop94]

example:

cell A1 contains the string "Bishop, Keith"
cell in B1 contains the string "Bishop, Keith1"

the conditional formatting in B1 needs to be something like: =A1<>B1 (but with a "1" found at the very end of the string in B1) then it will format that cell...

in other words, if the cells match the example above (they both contain the same string but in cell B it also must have a "1" at the end) , then the formula does nothing... otherwise they dont match and thus will then format accordingly... Thanks for any help

 

[felixstraube]

does something like this work?:

=(A1&"1")=B2

 

[kbishop94]

Thank you!

 

[felixstraube]

Thanks for the feedback. Happy to help