Hi All,
I am trying to find a way to disallow the entry of certain data depending on the value of another cell. I have a list of 13 items to choose from AD001, AD002 etc in one column and 4 workflows: 30, 75, v4 and v5 to choose from to populate the second column. We only use 12 at a time and for workflows v4 and v5 we aren't allowed to use AD013 and for 30 and 75 we're not allowed to use AD003. Is there a way to prevent entry of AD013 if the workflow is either v4 or v5 and same for AD003 if the workflow is 30 or 75.
Thanks you in advance,
Lucy
Bookmarks