How do I set up icons in excel in one column using data from anoth

W

Warwick

I fiddle around with shares and and want to show ups and downs. When I use
the arrows it takes the dat away so I want the arrow to show on say column C
but reading from the data in column B. There does not seem to be anywhere to
input source data.

Clear as mud!!!!!!!
 
J

joel

I figured out how to do what you want. I hope you are not using a
shape for the arrow because it won't work. You need to add a unicode
symbol to get it to work. Belwo is a sample of the results you are look
for.

=IF(A1 > 0,"↑","↓")


To get the up and down character you have to first add them to the
worksheet in a cell by using the worksheet menu Insert - Symbol. the
arrows are unicode numbers 2191 and 2193.
 
Top