You can also insert a smiley face (˜º˜»), by typing ALT+1 or 2 on the
numeric key pad)

Rhonda wrote:

Hey Guys,

Is it possible for me to insert a "smiley face" or "sad face" symbol in
blank cell next a cell that has a formula in it? For instance, if the time
in cell A1 is 2:00 (minutes) but the limit is 1:30, how can I put a "sad
face" symbol in the blank cell B1 automatically, see below for an example:

Cell A1 has a time of 2:20 PM (the maximum time should be 1:30 - this limit
is not in the spreadsheet). I want to have cell B1 automatically populate a
"sad face" because the maximum was over 50 minutes OR

Cell A1 has a time of 1:20 pm (the maximum time should be 1:30 - this limit
is not in the spreadsheet). I want to have cell B1 automatically populate a
"smiley face" because the limit was under the required 1:30.

Does this make sense? This is a spreadsheet that calculates the time
someone arrives to a clinic and time they leave, the maximum should be 1 hour
30 minutes for the person to go through the procedure but sometimes it does
not happen within that time, I want the spreadsheet to show when it does and
doesn't with the "smiley face" symbol.

I hope this was explained correctly, any help would be greatly appreciate!

Rhonda