Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use formula with data validation?
I am using data validation in a library index. column a is the group, column
b the sub-group. I want column b to validate particular data if column a is = to a particular group. Any suggestions? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I use formula with data validation?
"jb" wrote in message
... I am using data validation in a library index. column a is the group, column b the sub-group. I want column b to validate particular data if column a is = to a particular group. Any suggestions? Yes, you can. In the Data Validation pop-up, in "Allow" choose "Custom". This will open a new box in the pop-up called "Formula". The expert for data validation is MVP Debra Dalgleish, whose web site is he http://www.contextures.on.ca/tiptech.html There is a lot of good, detailed information about dependent lists, if that is what you need. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation with a formula | Excel Worksheet Functions | |||
Data validation formula | Excel Worksheet Functions | |||
data validation formula | Excel Discussion (Misc queries) | |||
Data validation Formula | Excel Discussion (Misc queries) | |||
Data Validation Formula Help | Excel Worksheet Functions |