spacemaid12
New Member
- Joined
- Apr 4, 2008
- Messages
- 35
Hi,
I have a spreadsheet where I have to input National Insurance numbers and I want to run some conditional formatting so that if a temporary NI number is input it highlights the cell.
The NI number cannot begin TN, there is then a string of 6 digits and thisis followed by either an A,B,C or D.
Can anyone help?
Thanks,
I have a spreadsheet where I have to input National Insurance numbers and I want to run some conditional formatting so that if a temporary NI number is input it highlights the cell.
The NI number cannot begin TN, there is then a string of 6 digits and thisis followed by either an A,B,C or D.
Can anyone help?
Thanks,