data - validation - list question

R

rwbaker

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
 
I

IanC

You can't have custom validation AND list validation. As you've discovered,
they are mutually exclusive. If you have list validation, the cell will only
accept entries on that list.

Create the list on your worksheet, then point to it by entering your range
of cells preceded by equals in the source field (eg =F7:F9).

I'm using Excel 2000 so the next bit may differ:

If your list is on another sheet or in another workbook, you will have to
create a named range and point to that in the source field instead (eg
=NamedRange).

Hope this helps.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top