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
