Hi all,

My name is Tom, and I'm a recent b-school IT grad. I'd love to say I'm nearly an expert with Excel, but there's something I swear I learned back in high school that I can't remember to save my life.

I would like to format cells to display a particular value when I enter something different. It's hard to explain it as a general problem, so more specifically:

I have a table with a list of characters in a game I play, and one property included is gender. Instead of displaying "Male" or "Female", I would like it to see the appropriate gender symbols (♂ and ♀) when I enter the respective gender. I want the symbol to display while I only have to type in the gender word.

Any tips?