Automatically inserting a symbol when text is entered in the cell

  • Thread starter Thread starter Frustratedfemale26
  • Start date Start date
F

Frustratedfemale26

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?
 
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?
Click to expand...

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
 
Back
Top