I have a cell in B* which can have either "Y" or "N"
its corresponding C* - Q* value can have freeform values if B* is "Y" but I only want to allow values from a list in C* (and not any other column) if B* is "N"
How possible is this and if it is how can I achieve it?
Joe
Bookmarks