I am trying to check a cell to see if it has a correct formatting for a serial number.  for example, if column b has serial numbers in it, I want to see if they follow a format of 2 letters and 6 numbers.

L=letters

N=numbers

LLNNNNNN

If not, I would like to either have it highlighted or I could put something in another column.  Just something to catch my eye for corrections.

I’m not great with formulas and my work excel is, I believe, the 2016 version.

​I am trying to check a cell to see if it has a correct formatting for a serial number.  for example, if column b has serial numbers in it, I want to see if they follow a format of 2 letters and 6 numbers.L=lettersN=numbersLLNNNNNNIf not, I would like to either have it highlighted or I could put something in another column.  Just something to catch my eye for corrections.I’m not great with formulas and my work excel is, I believe, the 2016 version.  Read More

​