Hi,
Been googling for the last three hours with no joy.
What I am trying to achieve is that when a user enters a value in cell d3 it tells them they can't if it is not in the correct format
The format is as follows:
AS-1234-5678-9111
AA-NNNN-NNNN-NNNN
Also the first two letters will always be AS if it makes it any easier?
Any suggestions as I didn't realise it would be this difficult?
Bookmarks