I'm just getting started with using validation, so I know the gist of
using data-validation to limit the input perameters, but I was
wondering if anyone could help me with something a bit more
complicated. In one cell, I want to limit the user to inputting either
a 1, 2, 3, or N/A. If they put a 1,2, or 3, they can continue across
the row, filling out the rest of the fields (patient data). If they
put an N/A, however, I'd like to somehow block them from entering any
data in the cells to the right of the cell with the N/A. I'm sure
excel can do this, I just couldn't find a tutorial about it.

Also, are there multiple types of "blocked" cells (i.e. locked, hidden,
darkened out, input error if anything is typed in it, etc.)? Is there a
way to do validation with each of them, or does validation only support
one type?

Thanks,
-RiotLoadTime


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