Hi all,
I'm trying to acheive Data Validation from a named range (ListName) along with not allowing empty/blank cells.
Cells in the spreadsheet by default consists of information alternative a hyphen (-) which is part of a List of items that are allowed.
But if someone deletes the content in a cell I need them to choose at least "-" if not one of the other allowed items in the list.

Initially I had the following as Data Validation:
=ListName

I found a thread which should force content in a cell (blanks not allowed):
=COUNTIF($B7:$NH200, "")=0

But I haven't been able to work out if it's possible to combine the two.

Hope it all makes sense.

Thanks in advance for any ideas.