Hi All,
RangeA
Cell Y1 contains text of OPT1
Cell Y2 contains text of OPT2
RangeB
Cell Z4 contains text of USER1
Cell Z5 contains text of USER2
In M5 is a dropdown containing choices of YES or NO.
In H8, how can I use data validation to show me only range Y1:Y2 if M5 is YES and range Z4:Z5 if M5 is NO.
I guess it requires a custom formula in the data validation setup but I can't get it to work. Could anyone help please!
Thanks,
RC
RangeA
Cell Y1 contains text of OPT1
Cell Y2 contains text of OPT2
RangeB
Cell Z4 contains text of USER1
Cell Z5 contains text of USER2
In M5 is a dropdown containing choices of YES or NO.
In H8, how can I use data validation to show me only range Y1:Y2 if M5 is YES and range Z4:Z5 if M5 is NO.
I guess it requires a custom formula in the data validation setup but I can't get it to work. Could anyone help please!
Thanks,
RC