Typing a letter in a cell to fill in another cell

[studio2006]

Hi

I really will appreciate your help in achieving the following:

I am wanting to be able to type a letter in a cell for example a letter Y that wil represent Yes.

As soon as a Y is entered in a cell I would like for a checkmark to be automatically checked in a different cell.

How do I achive this?

Thanks

[teylyn]

Hello,

say you enter a "y" in column G and you want column A to get a check mark:

In A1 use the formula

=IF(G1="y",CHAR(252),"")

Format the cell with the Wingdings font, then copy down.

You can also use checkboxes from the forms tools, but you will need to individually create these for each row. If you want to pursue that, please pipe up.

cheers

[studio2006]

Thank you - That did it.