Hi All,
I need to data validations for two different cells anyone able to assist

First cell needs to be in this format in numbers only
#####/##

Second needs to be a Letter followed by 6 numbers eg:
J123456

I have tried all types of formulas without any success