Set specififc format for cell

[max2599]

i have a power query file where random people enter data and then it comes to me but people entering data in wrong format for example there is field called plate number (see picture) is a correct format, I want to set specific format for this range so when anyone enter plate no in wrong format it will stop them thanks.




format.jpg

[bebo021999]

If the format is "XXX 0000" with three letters + blank + four digits
Use cell B2 to check
=IF(AND(AND(NOT(ISNUMBER(MID(A2,{1,2,3},1)+0))),MID(A2,4,1)=" ",ISNUMBER(RIGHT(A2,4)+0)),"OK","wrong")

[max2599]

If the format is "XXX 0000" with three letters + blank + four digits
Use cell B2 to check
=IF(AND(AND(NOT(ISNUMBER(MID(A2,{1,2,3},1)+0))),MID(A2,4,1)=" ",ISNUMBER(RIGHT(A2,4)+0)),"OK","wrong")

I don't want to check it. i want to stop people from entering data in wrong format. is there any way we can do it through format cells option.


Thanks

[max2599]

I find the solution myself,
1-You to create al list of all plate numbers in sheet 2,
2-Then go to sheet 1 and & select whole column except header
3-Select data validation > List
4-IN source box, select the list of plate numbers from sheet2
5-uncheck drop down feaur & press ok. thats it
Now if anyone type wrong plate number or in wrong format, ir will give them errior.


thanks all