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.

3. ## Re: test

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

4. ## 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

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. ## 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. ## Re: test

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

8. ## 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. ## Re: test

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

10. ## Re: test

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

Page 1 of 2 12 Last

#### Posting Permissions

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