I have been trying to add Data Validation to a cell. I have chosen "List" as my validation type, but I have not been able to figure out how I should enter the list in the text box to get it to work.
I have tried the following:
New, Deleted, Existing
'New', 'Deleted', 'Existing'
['New', 'Deleted', 'Existing']
What is the correct format to use for the List option in Data Validation?