B
boris
How do I make dynamic cell validation? In other words, I
want the list (or reference to a range for list options)
to change, based on the cell that is to the left of the
cell being validated.
Example:
A1 choices F or M
B1 choices If(A1=F, range1, if(A1=M, range2, range3)).
I know I have done something like this somewhere, but
can't remember where to look back.
Boris
want the list (or reference to a range for list options)
to change, based on the cell that is to the left of the
cell being validated.
Example:
A1 choices F or M
B1 choices If(A1=F, range1, if(A1=M, range2, range3)).
I know I have done something like this somewhere, but
can't remember where to look back.
Boris