| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 1 | 1998-09-01 00:09:00 | Smiley spreadsheets | Guest (0) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 37 | 2002-08-16 10:48:00 | If you have smiley faces in cells that will stuff up calculations won't it as it will cease to be a numeric cell unless you can do something in Control Panel/Regional Settings/Numbers. | mikebartnz (21) | ||
| 38 | 2002-08-16 11:37:00 | > If you have smiley faces in cells that will stuff up > calculations won't it as it will cease to be a > numeric cell unless you can do something in Control > Panel/Regional Settings/Numbers. What I believe that the person was after was that there will be 2 figures. For example sales for 2000 and 2001. If there has been an increase he wants a :) if there has been a decrease he wants a :(. So this would be done via an if statement or conditional formatting to compare the two values and work out what face to use. |
-=JM=- (16) | ||
| 39 | 2002-08-16 12:57:00 | Take note of what the original poster wants - a graphical indication of happiness or sadness in the cell to the left of the cell in question. Conditional formatting can only be applied to the cell in question. |
Russell D (18) | ||
| 40 | 2002-08-16 13:14:00 | Also note that Scott Bray, the original poster made this post back in 1998, Sept 1. This post only re-appeared because Mike is investigating forum linked-things again :D |
Jen C (20) | ||
| 41 | 2002-08-16 21:13:00 | > Not Mike, Jen. He was up to something... oh don't think so lowly of me, Susan! I might have been trying to help... :D but I wasn't ;) Mike. |
Mike (15) | ||
| 42 | 2002-08-16 21:15:00 | I have noticed though that the other threads I started (all test threads) at the same time as this one have been deleted... before I even got to read some of the replies :( This one, however, wasn't deleted... I wonder why? Mike. |
Mike (15) | ||
| 43 | 2002-08-16 21:16:00 | > Is that the first thread or the first that they've > still got though. I have no idea - I guess we'll have to ask Bruce or Robo Mike. |
Mike (15) | ||
| 44 | 2002-08-16 21:17:00 | > Also note that Scott Bray, the original poster made > this post back in 1998, Sept 1. > > This post only re-appeared because Mike is > investigating forum linked-things again :D Too right I was :) Mike. |
Mike (15) | ||
| 45 | 2004-12-19 06:30:00 | They... they had computers in 1998? | Growly (6) | ||
| 46 | 2004-12-20 02:25:00 | running win 98 and playing some old version of quake or doom | noone (22) | ||
| 1 2 | |||||