Thread: x means Y
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MitzDriver MitzDriver is offline
external usenet poster
 
Posts: 10
Default x means Y

How can I change a cell to either "Y" or "N" if the user enters "x".
i.e. If the user enters "x" in G12 and presses enter or moves to another
cell, that cell, G12, changes to "Y". Or the user enters "x" in H12 and
presses enter or moves to another cell, that cell, H12, changes to "N".

Thanks in advance for any help. And I hope I made sense.