x means Y
hi
sounds like all you need to do is add an entry into your auto correct options.
2003 toolsautocorrect optionsfollow the wizard.
regards
FSt1
"MitzDriver" wrote:
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.
|