Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Insert a Formula with a Macro | Excel Discussion (Misc queries) | |||
Insert Formula and Copy to other cells | Excel Discussion (Misc queries) | |||
Insert rows, keep a formula? | Excel Worksheet Functions | |||
Challenging Charting | Charts and Charting in Excel |