Thread: Using validation to block cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
RiotLoadTime RiotLoadTime is offline
external usenet poster
  
Posts: 1
Default Using validation to block cells

Thanks a lot Starguy, that helps quite a bit. I was wondering if you
also knew how to add additional validation to the cells in B:F so that
it's not only OR($AB3=1,$AB3=2,$AB3=3) but also the input user must
input a 0 or a 1. I tried =AND(OR($AB3=1,$AB3=2,$AB3=3),OR(0,1)), but
I obviously don't exactly know how the source field works.

Thanks again,
-RiotLoadTime


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

Reply With QuoteReply With Quote