Toggle cell values
Posted by Peter Bellinger on February 15, 2002 2:36 PM
How can you toggle the values of other cells.
The following example may help:-
Cells A1 to E1 must contain one 'Y' and the rest 'N's i.e. as a user types 'Y' into any of one cells the rest turn to 'N'
PS. Sorry if this has been asked many times before but I could not find the answer.
Thanks
Pete