software

I want to be able to display up and down arrows pertaining to price movements
in a spreadsheet?

Use the Insertgt;Symbol... command. It will tell you the character number of the
symbol you want to use. Then put that in an If statement, as in:

=if(a1lt;b1,char(223),char (221))

Does this help?

--
Regards,
Fredquot;Templetonquot; gt; wrote in message
...
gt;I want to be able to display up and down arrows pertaining to price movements
gt; in a spreadsheet?
Thankyou, but is it possible to colour code them as well??

quot;Fred Smithquot; wrote:

gt; Use the Insertgt;Symbol... command. It will tell you the character number of the
gt; symbol you want to use. Then put that in an If statement, as in:
gt;
gt; =if(a1lt;b1,char(223),char (221))
gt;
gt; Does this help?
gt;
gt; --
gt; Regards,
gt; Fred
gt;
gt;
gt; quot;Templetonquot; gt; wrote in message
gt; ...
gt; gt;I want to be able to display up and down arrows pertaining to price movements
gt; gt; in a spreadsheet?
gt;
gt;
gt;

You would do that by formatting the cell.

Anticipating your next question, if you want to use green if the price is up,
and red if the price is down, use Conditional formatting.

Post back if you want help with either of these. A specific example would be
useful so we can help you get exactly what you want.

--
Regards,
Fredquot;Templetonquot; gt; wrote in message
...
gt; Thankyou, but is it possible to colour code them as well??
gt;
gt; quot;Fred Smithquot; wrote:
gt;
gt;gt; Use the Insertgt;Symbol... command. It will tell you the character number of
gt;gt; the
gt;gt; symbol you want to use. Then put that in an If statement, as in:
gt;gt;
gt;gt; =if(a1lt;b1,char(223),char (221))
gt;gt;
gt;gt; Does this help?
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt; Fred
gt;gt;
gt;gt;
gt;gt; quot;Templetonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I want to be able to display up and down arrows pertaining to price
gt;gt; gt;movements
gt;gt; gt; in a spreadsheet?
gt;gt;
gt;gt;
gt;gt;
Fred, thanks for that but when I inserted the character reference it would
not accept the formula as the character reference had a combination of
Alpha/Numerics.
Maybe it's a language issue, or maybe there are specific symbols which you
can use in this case. Cell comes up with the #Value error.
You are correct in assuming the next question is about conditional
formatting, this I can do, it seems to be getting the symbol to display
correctly. I could get it to work with an Arabic symbol but not the arrows.

Ian T

quot;Fred Smithquot; wrote:

gt; You would do that by formatting the cell.
gt;
gt; Anticipating your next question, if you want to use green if the price is up,
gt; and red if the price is down, use Conditional formatting.
gt;
gt; Post back if you want help with either of these. A specific example would be
gt; useful so we can help you get exactly what you want.
gt;
gt; --
gt; Regards,
gt; Fred
gt;
gt;
gt; quot;Templetonquot; gt; wrote in message
gt; ...
gt; gt; Thankyou, but is it possible to colour code them as well??
gt; gt;
gt; gt; quot;Fred Smithquot; wrote:
gt; gt;
gt; gt;gt; Use the Insertgt;Symbol... command. It will tell you the character number of
gt; gt;gt; the
gt; gt;gt; symbol you want to use. Then put that in an If statement, as in:
gt; gt;gt;
gt; gt;gt; =if(a1lt;b1,char(223),char (221))
gt; gt;gt;
gt; gt;gt; Does this help?
gt; gt;gt;
gt; gt;gt; --
gt; gt;gt; Regards,
gt; gt;gt; Fred
gt; gt;gt;
gt; gt;gt;
gt; gt;gt; quot;Templetonquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I want to be able to display up and down arrows pertaining to price
gt; gt;gt; gt;movements
gt; gt;gt; gt; in a spreadsheet?
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

You lost me. There should be no reason this doesn't work. What formula did you
use?

--
Regards,
Fredquot;Templetonquot; gt; wrote in message
...
gt; Fred, thanks for that but when I inserted the character reference it would
gt; not accept the formula as the character reference had a combination of
gt; Alpha/Numerics.
gt; Maybe it's a language issue, or maybe there are specific symbols which you
gt; can use in this case. Cell comes up with the #Value error.
gt; You are correct in assuming the next question is about conditional
gt; formatting, this I can do, it seems to be getting the symbol to display
gt; correctly. I could get it to work with an Arabic symbol but not the arrows.
gt;
gt; Ian T
gt;
gt; quot;Fred Smithquot; wrote:
gt;
gt;gt; You would do that by formatting the cell.
gt;gt;
gt;gt; Anticipating your next question, if you want to use green if the price is up,
gt;gt; and red if the price is down, use Conditional formatting.
gt;gt;
gt;gt; Post back if you want help with either of these. A specific example would be
gt;gt; useful so we can help you get exactly what you want.
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt; Fred
gt;gt;
gt;gt;
gt;gt; quot;Templetonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Thankyou, but is it possible to colour code them as well??
gt;gt; gt;
gt;gt; gt; quot;Fred Smithquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Use the Insertgt;Symbol... command. It will tell you the character number of
gt;gt; gt;gt; the
gt;gt; gt;gt; symbol you want to use. Then put that in an If statement, as in:
gt;gt; gt;gt;
gt;gt; gt;gt; =if(a1lt;b1,char(223),char (221))
gt;gt; gt;gt;
gt;gt; gt;gt; Does this help?
gt;gt; gt;gt;
gt;gt; gt;gt; --
gt;gt; gt;gt; Regards,
gt;gt; gt;gt; Fred
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Templetonquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I want to be able to display up and down arrows pertaining to price
gt;gt; gt;gt; gt;movements
gt;gt; gt;gt; gt; in a spreadsheet?
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;