"Defined Names" into "Data Validation" problem

Hi guys,


when I plug a "Defined Names" into a "Data Validation" list, the Data Validation's "Error Alert stops"

I want to be able to use "Defined Names" in "Data Validation" and have error alerts appear to the user, if the cell isn't an entry found within the Defined Names.

Any ideas?
Thanks!

That is a pretty general description--too general to actually be answered.

I assume you are talking about using the List option. Can you give the specifics of what defined name you are using? What formula does it name?

Hi Jimmy,

I think you need to put an equal sign in front of the DefineNames list in the Validation dialog. I also think you can't have a space in the name. See my example.
Validation List needs Equal Sign.xlsx

Hi,

thanks for the reply.

See my sheet, I am having some trouble with conditional formatting and words.

'=AND(IF($A2>6,TRUE,FALSE),IF($A2<>"Mary",TRUE,FALSE))

Your latest problem seems to be different than your original question. Here is the solution to your conditional formatting question:

Formula:

=AND(ISNUMBER($A31),$A31>5)