I have a workbook with 26 sheets in it and I have a column that has a drop down menu as a list, which contains: Phone, Website, Website, Website form. I want to add 'Other' to this selection and when 'Other is selected I want to open a pop up box to give a message . I have tried using data validation but it applies the pop up to all entries, whereas I just want it to open when 'Other' is selected. I have also looked at conditionality formatting but still can't get it to work. Any help would be much appreciated