| 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?
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 |
|
#7
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 |
|
#8
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 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Instead of the word "dropped" could I use an arrow?
Ahh, my crazy IT group has remove it from my system. Crazy, a? I will try to
get them to reinstall. Do you know of a website that may have them all listed? "Dave Peterson" wrote: 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 |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Instead of the word "dropped" could I use an arrow?
I don't know where it can be downloaded.
But maybe you can go into control panel and see if you can add the accessories to Windows (add/remove programs, then Add/remove windows components (under accessories and utilities). (in WinXP anyway) pgarcia wrote: Ahh, my crazy IT group has remove it from my system. Crazy, a? I will try to get them to reinstall. Do you know of a website that may have them all listed? "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Instead of the word "dropped" could I use an arrow?
Ok, go the Chart map. Do you know how to translate the character code?
0x77 = ? Thanks "Dave Peterson" wrote: I don't know where it can be downloaded. But maybe you can go into control panel and see if you can add the accessories to Windows (add/remove programs, then Add/remove windows components (under accessories and utilities). (in WinXP anyway) pgarcia wrote: Ahh, my crazy IT group has remove it from my system. Crazy, a? I will try to get them to reinstall. Do you know of a website that may have them all listed? "Dave Peterson" wrote: 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 -- Dave Peterson |
|
#12
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Instead of the word "dropped" could I use an arrow?
Only by opening Character map and scrolling through the list.
You can see the hex representation for any selected symbol at the bottom of the dialog. Or you could convert your hex number to decimal (=hex2dec()) and use =char() to see the result--format it as your favorite font. So with 77 in A1 and this in B1: =CHAR(HEX2DEC(A1)) I saw a w (using the Arial font). pgarcia wrote: Ok, go the Chart map. Do you know how to translate the character code? 0x77 = ? Thanks "Dave Peterson" wrote: I don't know where it can be downloaded. But maybe you can go into control panel and see if you can add the accessories to Windows (add/remove programs, then Add/remove windows components (under accessories and utilities). (in WinXP anyway) pgarcia wrote: Ahh, my crazy IT group has remove it from my system. Crazy, a? I will try to get them to reinstall. Do you know of a website that may have them all listed? "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
|
#13
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Instead of the word "dropped" could I use an arrow?
Cool, I have the number ofthe char map in A1 and B1 I have =hex2dec(B2) then
c1 has =char(B2), C1 font is Wings and that did, THANKS. "Dave Peterson" wrote: Only by opening Character map and scrolling through the list. You can see the hex representation for any selected symbol at the bottom of the dialog. Or you could convert your hex number to decimal (=hex2dec()) and use =char() to see the result--format it as your favorite font. So with 77 in A1 and this in B1: =CHAR(HEX2DEC(A1)) I saw a w (using the Arial font). pgarcia wrote: Ok, go the Chart map. Do you know how to translate the character code? 0x77 = ? Thanks "Dave Peterson" wrote: I don't know where it can be downloaded. But maybe you can go into control panel and see if you can add the accessories to Windows (add/remove programs, then Add/remove windows components (under accessories and utilities). (in WinXP anyway) pgarcia wrote: Ahh, my crazy IT group has remove it from my system. Crazy, a? I will try to get them to reinstall. Do you know of a website that may have them all listed? "Dave Peterson" wrote: 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 -- Dave Peterson -- Dave Peterson |
| 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) | |||
Linear Mode
