Wally,

You need to use an allow type of list for that formula, not Custom.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Wally" wrote in message
...
I am using this formula in hopes of having a drop down list appear in
column
J if "Yes" is selected from a drop down list in column I.

=IF(I2="Yes",Paint,"").

"Paint" is the name of my list and it has about 50 different types and
colors of paint. When I select "Yes", only the first item of the list
appears
and there is no arrow to make a different selection.

I also want the J column to be blank if the next user selects "No" and
default to "No" when cell A2 changes or when the document is first opened.

Any help would be greatly apreciated!