Page 1 of 2 12 LastLast
Results 1 to 10 of 20
  1. #1
    Guest

    Default Smiley spreadsheets

    The other day I attended a seminar on budgeting. The trainer used a smiley face or a sad face instead of a plus or minus next to the budget figures as he said these smiley/sad faces are less confusing than the traditional +/- in budgets. I thought this was a good idea. The trainer used a Word table for the figures but I'm wondering how I can format an Excel 97 cell so a positive number shows a smiley face to the left of the figure in the same cell, and a negative figure shows a sad face to the left of the figure in the same cell.

    This might have something to do with conditional formatting in a cell or there may be some simple method that I am overlooking but I cannot see how it can be done.

  2. #2
    Mike
    Guest

    Default test


  3. #3
    -=JM=-
    Guest

    Default Re: test

    please tell me that, that was not the desired out come.

  4. #4
    Capt Jimbo
    Guest

    Default Re: test

    I would suggest you use an if statement in the next column to show a Smiley or Sad face as appropriate.
    You'll have to put the smiley/sad faces in a reference cell somewhere
    Something along the lines of:
    =if(A1>0,B1,B2)
    Where B1 and B2 contain he smiley/sad face
    May be a shorter way to get there but this will work

    Capt Jimbo

  5. #5
    Russell D
    Guest

    Default Re: Smiley spreadsheets

    The WINGDINGS font shows "J" as a smiley face and "L" as a sad face.
    Use an IF formula in B1 such as =IF(C1>0,"J","L") then format B1 as WINGDINGS font.
    For a bit of fun, format the cell before entering the formula!

  6. #6
    Mike
    Guest

    Default Re: test

    > please tell me that, that was not the desired out
    > come.

    no, of course it wasn't the desired outcome... but interesting anyway - that was the first post (thread #1)...

    Mike.

  7. #7
    -=JM=-
    Guest

    Default Re: test

    Is that the first thread or the first that they've still got though.

  8. #8
    Susan B
    Guest

    Default Re: test

    > Is that the first thread or the first that they've
    > still got though.

    Message is from 1 September 1998 so I guess that's when the forum was born?

    That Mike gets bored too much.

  9. #9
    Jen C
    Guest

    Default Re: test

    What is more amusing is that people blindly (kindly) reply to posts that are nearly 4 years old! :^O

  10. #10
    Susan B
    Guest

    Default Re: test

    Not Mike, Jen. He was up to something...

Similar Threads

  1. Smiley face?
    By Sweep in forum PC World Chat
    Replies: 1
    Last Post: 01-05-2008, 10:56 AM
  2. A Smiley time
    By beetle in forum PC World Chat
    Replies: 3
    Last Post: 06-09-2005, 07:47 PM
  3. email add on :Smiley central.
    By beetle in forum PressF1
    Replies: 9
    Last Post: 06-04-2004, 07:42 PM
  4. Spreadsheets
    By Phil1 in forum PressF1
    Replies: 8
    Last Post: 24-01-2004, 08:15 PM
  5. spreadsheets
    By in forum PressF1
    Replies: 0
    Last Post: 19-09-2000, 09:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •