How to format a cell if part of the text does not match another part of the text

[steph0580]

Hi,

I have a spreadsheet where customer codes are entered. All customer codes start with C and then the letter of the depot followed by 6 digits, a dash, and then the depot letter again. For example, CM123456-M. Is there a way to highlight the cell if the end letter has been input incorrectly and does not match the second letter? For example, CM123456-N instead of -M?

Many thanks

 

[Fluff]

You can use conditional formatting, New Rule > Use a formula > =RIGHT(A1,1)<>MID(A1,2,1) > & select the format

 

[steph0580]

Thank you so much! That worked perfectly

 

[Fluff]

Glad to help & thanks for the feedback