data validation-setup a validation rule

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

That works perfectly. However, i would also need to add to that criteria text strings like "Free", Faulty", etc.

Do i need another instance of the If statement, or can i make it part of the same If arguement?

Please advise.

Thanks again

D