One or the other, not both.

If the items in the dropdown list are in conflict with the current DV
restrictions you are out of luck.

Can you in some way combine the two?

Post some examples of existing rules and items to be "listed"


Gord Dibben MS Excel MVP

On Fri, 28 May 2010 05:52:01 -0700, rwbaker
wrote:

excel 2003
I have several cells that I have some custom data validation configured
I also want to have a in-cell drop down list for these cells

Can some please tell me how I can do this

I go to the data - validation and select list but it seems to take away the
custom data valadation I have