Data Validation Rules for a List of Patterns

[hasan mougharbel]

Hello everyone, I hope you're doing well today. I want a data validation rule for a set of cells in my Excel sheet. I want to ensure that the cell content matches only one of the following patterns (different numbers are inserted but with exact characters as below):

"Order # 12345"
"Order # 921222"
"Order # 23456 / Order # 921222"
"Order # 23456 / Order # 23456 / Order # 234256"

I'm looking for guidance on how to set up a data validation rule for this in Excel. I have around 120 cells where this rule is to be applied.

Is this rule sophisticated enough for a standard data validation rule, or should I consider using array tables or lists?
I appreciate any kind of help

[JohnTopley]

You should know by now that you get a quicker reply with a sample workbook!