View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cjtj4700
 
Posts: n/a
Default Excel formula(?) for choosing only 1 cell..

Hi ~ Is it possible to create a formula or rule that allows only 1 cell
within a designated range to be selected? Similar to a survey where the user
can only choose 1 option.This is for an internal shipping request form and I
want requestors to be able to select only 1 service level (overnight, ground,
etc.). So if they click on one then change their mind, clicking on the
correct box "moves" the check mark.

Thx