Hi
OP can be found here, and thanks to MickG for solving my original problem.
https://www.excelforum.com/excel-pro...g-in-cell.html
As my workbook has been put in to use there are a couple of issues that have become apparent.
This code by Mick does exactly what I needed and highlights the row if the number prefixed with "A" doesn't match 10 digits.Please Login or Register to view this content.
I don't want this to change as I still need to highlight incorrect reference numbers.
However, I have found people referencing specifically to "A2", so this is also highlighting as it has prefix "A" but only one digit. So previous code will highlight it red.
Is there a way of keeping the original code so that reference numbers with prefix "A" that don't have 10 digits highlight red but if the string in cell contains specifically "A2" then it doesn't highlight?
I hope that makes sense.
TIA
Tez
Bookmarks