Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I would like to use validation "List from a range" in all the cells of column B only if in the correspondent cell in column A there is data in it.
Is there a way to do it?
List from a range option of data validation doesn't work that way. You could try to use a custom formula, but this option doesn't show a dropdown.
Required, but never shown