hello try this.
select your range at the right of your column in which you have allowed
values 1,2,3,N/A
go to menu Data Validation under Allow select Custom and put this
formula.

AND(OR($AB3=1,$AB3=2,$AB3=3),OR(AC=0,AC=1))

hopefully this would solve your problem.

RiotLoadTime Wrote:
Starguy,

Sorry, I meant allowing the user to only input a 0 or 1 -in the cells
B:F-.

So in all: a user can only input a value into cells B:F if the
corresponding value in column A is a 1,2,3. Also, the value they put
in B:F can only be a 0 or 1

Thanks,
-RiotLoadTime


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=569856