Can I use formula with data validation?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
jb said:
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?
Click to expand...

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.
 
Back
Top