Can I use formula with data validation?

[Guest]

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?

 

[Stephen]

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
here:
http://www.contextures.on.ca/tiptech.html
There is a lot of good, detailed information about dependent lists, if that
is what you need.