Conditional Data Validation through List

caabdul

New Member
Joined
Dec 25, 2011
Messages
9
Hello experts,

I have applied data validation through list in excel 2013.
That list contains some cells in which text does not start with two minus signs i.e. "--".

I want my data validation to expand in such a way that only cells started with "--" are picked and other are not allowed.

EXAMPLE
=======
List
A1 [Services]
A2 [--Teaching]
A3 [Jobs]
A4 [--Management]

I want to allow only A2 and A4 type of data (that starts with "--") through data validation.

Please note that drop down list is a must have.

I hope my situation is well described, however anything else you want to know, please let me know.

Thanks to all!
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Forum statistics

Threads
1,223,721
Messages
6,174,091
Members
452,542
Latest member
Bricklin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top