I currently have a table which includes cells with drop down lists, however I want to be able to determine what cells can be filled out - for example if column A = Pending then if you try and enter information into column B it won't be accepted, but if column A = Shipped then information can be entered into column B but it still has to be selected from the drop down list in column B. Is there a way to do this? TIA
Bookmarks