Last week I asked the question above and I got a couple great responces.
However, the programming response allowed me to only deal with one column and
I need to be able to enter a "Y" into any cell within 2 columns in the
worksheet and have it return in the same cell the word "YES". Can someone
please help me?

It was also suggested that I have the auto fill turned on and I would only
have to type the word "YES" once then "Y" and enter after that. This doesn't
seem to work in all areas of the worksheet. I end up having to type the
whole word in each section of the worksheet. Am I missing a setting or
something?