Data Validation list error

I have one cell with data validation list applied without the error, so the user can select from the drop down list or type their own input. On the same sheet I'd also like another cell to have data validation applied with a different list and to have the invalid entry error on so they can only choose from the list. But when I try this on the second cell it's still letting me input any entry even with the error alert on. Can I only have one type of data validation list for the whole active sheet?

Originally Posted by c.davidson

I have one cell with data validation list applied without the error, so the user can select from the drop down list or type their own input. On the same sheet I'd also like another cell to have data validation applied with a different list and to have the invalid entry error on so they can only choose from the list. But when I try this on the second cell it's still letting me input any entry even with the error alert on. Can I only have one type of data validation list for the whole active sheet?

Hi again,

You can have multiple data validation on 1 sheet

See attached.

My bad, see new attached - second data validation is restricted