Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of the word "dropped" could I use an arrow?
In my spread sheet I would like to us a arrow to show if an amount dropped or
went up in amount. This is what I have for now: =IF(D31E31,"Up","Dropped") I would like to have a black arrow for up and a red one for dropped. VB maybe? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of the word "dropped" could I use an arrow?
format the cell with the formula for the font windings
=IF(D31E31,char(233),char(234)) or use another font that has an arrow more to your liking - but you see the approach. -- Regards, Tom Ogilvy "pgarcia" wrote: In my spread sheet I would like to us a arrow to show if an amount dropped or went up in amount. This is what I have for now: =IF(D31E31,"Up","Dropped") I would like to have a black arrow for up and a red one for dropped. VB maybe? Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of the word "dropped" could I use an arrow?
Where can I see this code? I can not seem to locat the character map.
"Tom Ogilvy" wrote: format the cell with the formula for the font windings =IF(D31E31,char(233),char(234)) or use another font that has an arrow more to your liking - but you see the approach. -- Regards, Tom Ogilvy "pgarcia" wrote: In my spread sheet I would like to us a arrow to show if an amount dropped or went up in amount. This is what I have for now: =IF(D31E31,"Up","Dropped") I would like to have a black arrow for up and a red one for dropped. VB maybe? Thanks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of the word "dropped" could I use an arrow?
WingDings is a font that you get through FormatCellsFont
The code Tom gave you is a formula to be pasted into the cell where you want the arrow to appear. "pgarcia" wrote: Where can I see this code? I can not seem to locat the character map. "Tom Ogilvy" wrote: format the cell with the formula for the font windings =IF(D31E31,char(233),char(234)) or use another font that has an arrow more to your liking - but you see the approach. -- Regards, Tom Ogilvy "pgarcia" wrote: In my spread sheet I would like to us a arrow to show if an amount dropped or went up in amount. This is what I have for now: =IF(D31E31,"Up","Dropped") I would like to have a black arrow for up and a red one for dropped. VB maybe? Thanks |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of the word "dropped" could I use an arrow?
Sorry, I guess I was not clear. How do you know what char 234 is?
"JLGWhiz" wrote: WingDings is a font that you get through FormatCellsFont The code Tom gave you is a formula to be pasted into the cell where you want the arrow to appear. "pgarcia" wrote: Where can I see this code? I can not seem to locat the character map. "Tom Ogilvy" wrote: format the cell with the formula for the font windings =IF(D31E31,char(233),char(234)) or use another font that has an arrow more to your liking - but you see the approach. -- Regards, Tom Ogilvy "pgarcia" wrote: In my spread sheet I would like to us a arrow to show if an amount dropped or went up in amount. This is what I have for now: =IF(D31E31,"Up","Dropped") I would like to have a black arrow for up and a red one for dropped. VB maybe? Thanks |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of the word "dropped" could I use an arrow?
Char(234) is an ASCII code which will print a character of some type
depending on which font is being used. You can do the same thing with the code that eliano has supplied you. The point of using either of formulas is that the arrow symbol resides in the WingDings font. If the cell is formatted for WingDings either formula should work. "pgarcia" wrote: Sorry, I guess I was not clear. How do you know what char 234 is? "JLGWhiz" wrote: WingDings is a font that you get through FormatCellsFont The code Tom gave you is a formula to be pasted into the cell where you want the arrow to appear. "pgarcia" wrote: Where can I see this code? I can not seem to locat the character map. "Tom Ogilvy" wrote: format the cell with the formula for the font windings =IF(D31E31,char(233),char(234)) or use another font that has an arrow more to your liking - but you see the approach. -- Regards, Tom Ogilvy "pgarcia" wrote: In my spread sheet I would like to us a arrow to show if an amount dropped or went up in amount. This is what I have for now: =IF(D31E31,"Up","Dropped") I would like to have a black arrow for up and a red one for dropped. VB maybe? Thanks |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of the word "dropped" could I use an arrow?
Windows Start button|Run
type: charmap and hit enter In WinXP, CharMap is buried under the Accessories|System Tools program group. ps. If you're using office 2002+, you can use: Insert|symbol Chip Pearson has an addin that may help (if you're using xl2k or lower). http://www.cpearson.com/excel/download.htm (look for Symbolizer and make sure you get the correct version) pgarcia wrote: Sorry, I guess I was not clear. How do you know what char 234 is? "JLGWhiz" wrote: WingDings is a font that you get through FormatCellsFont The code Tom gave you is a formula to be pasted into the cell where you want the arrow to appear. "pgarcia" wrote: Where can I see this code? I can not seem to locat the character map. "Tom Ogilvy" wrote: format the cell with the formula for the font windings =IF(D31E31,char(233),char(234)) or use another font that has an arrow more to your liking - but you see the approach. -- Regards, Tom Ogilvy "pgarcia" wrote: In my spread sheet I would like to us a arrow to show if an amount dropped or went up in amount. This is what I have for now: =IF(D31E31,"Up","Dropped") I would like to have a black arrow for up and a red one for dropped. VB maybe? Thanks -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Instead of the word "dropped" could I use an arrow?
Hi pgarcia.
Try: =IF(D31E31;"h";"i") formatting Wingdings 3 and Bold Regards Eliano On 13 Set, 22:32, pgarcia wrote: In my spread sheet I would like to us a arrow to show if an amount dropped or went up in amount. This is what I have for now: =IF(D31E31,"Up","Dropped") I would like to have a black arrow for up and a red one for dropped. VB maybe? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tab, "up" and "down" arrow keys in Excel | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
How do I set "tab" or "arrow" key to automatically highlight a cel | Excel Discussion (Misc queries) |