vaidation for the serial number

[pyajmal]

Here I am attached my worksheet

[#2 · Accepted solution]

Hia,

i've attached a copy of your workbook that has both a column that says Check Number if there is a missmatch and changes the colour, you can pick which you like more..

 =IF(RIGHT(A4,MIN(LEN(A4),3))=RIGHT(G4,MIN(LEN(A4),3)),"","CheckNumber")

the formula is like this as not all of your numbers in the A column are 3 digits long, with this if they are smaller then it still works.