I have a sheet which has many columns. in one column, I have values as below. I just want to create a rule/pop up window etc if user enter A-31 or A-24B then excel will say no you can not enter these values. Any hint/idea would be very much appreciate it. Thank you.