Ticks/Crosses in cells?

Hi folks,

I have a list of names of people that have answered a question with the reply "yes" or "no". Their answers are in column B. Is there any way of making the "yes"s a tick symbol and the "no"s a cross symbol using the IF statement?? Even better if I could get ticks in green and crosses in red.

This would be a big help.

thanks

Suppose you have the yes or no in cell A1 then use:
=IF(A1="yes",CHAR(252),IF(A1="no",CHAR(251),""))

Format the font of the result cells as Windings.

As for the color: use conditional formatting. Example, if you have entered the above formula in cell B1 then, select format > conditional formatting
In condition 1, select "formula is" in the drop-down, and enter the following =B1=CHAR(252). Click format button and select green color for the font. Then click on ADD>> and in the second condition enter =B1=CHAR(251) after selecting formula is. Format the font as red.

Copy the formatting to all the cells.

- Mangesh

Mangesh,

genius mate!! thanks