data - validation - list question
 

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

data - validation - list question
 

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.

--
Ian
--

"rwbaker" wrote in message
...
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

data - validation - list question
 

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