Hi,
Does anybody know how to change data validation type depending on the contents of a cell?
Whereas I can use lists and indirect for a list in B1 depending on the contents of A1, how could I make the data validation for B1 force a date, if depending on A1?
(Moderator - I'm guessing it'll need some VBA, so should this post sit in that forum?)
Does anybody know how to change data validation type depending on the contents of a cell?
Whereas I can use lists and indirect for a list in B1 depending on the contents of A1, how could I make the data validation for B1 force a date, if depending on A1?
(Moderator - I'm guessing it'll need some VBA, so should this post sit in that forum?)