Data substitution [SOLVED]

[Basil]

First, I want to say this is a cool forum I have learned a lot from other people's questions. Now I have one and as usual, it is probably something simple I am missing...


I want to have Excel display a wing ding check mark when a user types "y" in a cell. I have been trying to do a substitute formula but putting the symbol in an unused portion of the spreadsheet and calling it to the selected cell but I can't get it to work. Any thoughts?

 

[Axim5]

Here's it can be done.


Let's say A1 is where user types in "Y", in B1 change the font format to Windings and also in B1 type/copy the following formula;


IF(A1="Y","ü","-")


In the above formula the character "ü" represents the Winding checkmark.Try it

 

[Basil]

Thanks, I'll try that.

 

[Yarko]

Suggest you modify Axim5 formula to: =IF(OR(A1 = "y", A1 = "Y"), "ü","")

This will cover both upper or lower case inputs and only put a check mark in if the condition is met, otherwise B1 remains blank.

 

[keymaster]

I have posted about this on the blog today... with 2 more ways to do it. http://chandoo.org/wp/2009/09/15/get-tick-marks-in-excel/