I would like to control a cell value based on a value entered in another cell. For example, If in A1 "x" is entered then B1 can hold anything in range 2-4.
If in A1 "y" is entered then B1 can only be 0.
Currently I have Data Validation lists for both A1 and B1, but i want to add this extra validation step.
Any help is greatly appreciated.
Custom validation for B1: =OR(AND(A1="y", B1=0), AND(A1="x", B1>=2, B1<=4))
If there's already validation, then you'd need to integrate it.
Microsoft MVP - Excel
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks