Data Validation Restricts a Cell Based on Value Entered

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?

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I’ll simplify it: Cell A1 is allowed a zero (0) with B1 being blank. If a one (1) is entered in A1, the user is not allowed to do so until B1 is filled. (B1 has a list.)

Sorry but I don'yt understand the logic:

IF A1=0, then B1 must be blank

If A1=1, B1 is a named list

IF A1=2 ???

You can do something like this:

in A1

DV

=list

Sourcce:0,1,2

in B1

DV

=List

=IF(A1=0,Blank,IF(A1=1,List1,List2))

Where Blank is named range (Blank cell), List1 is named range list for A1=1, List2 is named range list for A1=2

I’m sorry! I’m sorry! Take away the drop-down lists and all. Let me try something else. For data validation, if you put a zero (0) in A1, NOTHING HAPPENS from a data validation standpoint. If you try to put anything greater than zero, you’re not allowed. You’re told that B1 needs a value first. (B1 has a drop-down, but that is unimportant at the moment.)

I figured it out
=IF($A1>0,$B1<>"",$B1=""). Uncheck ignore blank.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.