I want to be able to automatically insert a tick symbol and a cross symbol
into a cell when either a Y or a N is entered into the cell. Can this be
done?

On Aug 28, 9:15*am, Frustratedfemale26
wrote:
I want to be able to automatically insert a tick symbol and a cross symbol
into a cell when either a Y or a N is entered into the cell. *Can this be
done?

It can be done via an event-handler macro that could be written to
check when anyone enters a Y or a N in a particular range of cells
then change the value to a tick or a cross (probably from the
wingdings font), but what you could do as an alternative (which is
easier and might be more effective) is to use conditional formatting
(Format Conditional Formatting if you are in excel 2000-2003) to
format the font or the entire cell to be say, Bold & Green when a Y is
entered and Bold & Red when a N in entered.

Hope this helps

Stuart
www.insightmodelling.co.uk