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