Automatically inserting a symbol when text is entered in the cell
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? |
Automatically inserting a symbol when text is entered in the cell
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 |
All times are GMT +1. The time now is 03:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com