Thankyou, but is it possible to colour code them as well??

"Fred Smith" wrote:

Use the InsertSymbol... 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(a1<b1,char(223),char (221))

Does this help?

--
Regards,
Fred


"Templeton" wrote in message
...
I want to be able to display up and down arrows pertaining to price movements
in a spreadsheet?