Column A will have either a zero (0), one (1), or two (2) entered in the cells. The data validation will allow a zero (0) to be entered and nothing will happen. If a one (1) or two (2) is to be entered, the data validation will prompt a user to choose from a named list (drop-down) in column B first. Only then may a number equal to or great than one (1) be entered in column A. I need a data validation formula that will be placed into a table as a calculated column to reflect this.
Help?
Bookmarks