microsoft+excel+training+london - Pivot tables

Hi Russel, Thanks for the post, I hope you enjoyed your courses, in response to your question; to create a validation rule, now which one is my question? If you go to the menu command Data and choose Validation you will open a dialog box which will give you a number of choices, choose the type of validation you wish to apply to the cell and follow the steps that are indicated. dont forget to add a pre-entry message or instructions and also a message which will display if the entry is incorrect. I hope that answers your question, best regards Pete.