Hi all,

I need to setup a validation rule that would permit entries like those that follow:

- 8 digit number that MUST commence with 200 (i.e. 20012345, 20034342,
etc).

- The words "Free" , "Faulty" and "Employee"

I would the user to receive an error message is any of the above is not met, buit no need for a message before entering the data.

This rule will be applied to a single column (i.e. Column A)

Would have prefered to send you how far i've got with code, but not sure how to even start this one. Not even using the Excel 2007 Data Validation wizards.

Hope you can help,

Million thanks

D