Hi,
I would like to add a validation list to a cell in case an other cell has a specific value.
Let's say A1='myvalue' then A2 should have a validatin list from a named range that called "Mylist", else it should be "no list available"
How could I do it?
Thank you
Bookmarks