excuse me guys....how to do it in the formula if A1 must be the current
ticking time....thanks
--
"Bright minds are blessed to those who share them.."-rsb.


"Bernie Deitrick" wrote:

Rhonda,

Download a font that includes smiley faces as individual characters, then write the formula to
return the correct character number, and format the cell for that font. Use a formula like

=IF(A1VALUE("1:30:00"),CHAR(65),CHAR(66))

HTH,
Bernie
MS Excel MVP


"Rhonda" wrote in message
...
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