Is this possible

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 2 numbers and i want to have a column that shows the difference between the two. is there a way to have an green arrow pointing up if the difference is positive as well as the size of the move and vice versa a red down arrow for negative changes. eg "1" "3" "Up 2" where up is actually a green arrow

I hope this makes sense and can be don
 
Hi

You can use an IF formula to put a character in a cell, like
=IF(A1<B1,CHAR(225),IF(A1>B1,CHAR(226),CHAR(224)))
then format it Wingdings so that the characters are represented by arrows,
and finally apply conditional formatting to color them. Then use the
neighbor cell for the diff number -can't have them both in the same cell I
think.

HTH. Best wishes Harald

kevin said:
I have 2 numbers and i want to have a column that shows the difference
Click to expand...
between the two. is there a way to have an green arrow pointing up if the
difference is positive as well as the size of the move and vice versa a red
down arrow for negative changes. eg "1" "3" "Up 2" where up is actually a
green arrow.
 
Put in say A1: =CHAR(ROW())
Copy A1 down to A255

--
Rgds
Max
xl 97
--
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
---
kevin said:
wow thanks. is there a place where i can see a list of all the characters
Click to expand...
to see what possibilities there are and their char number?
 
Repeat formula also in B column, C column, ... and format them with fonts
Webdings, Symbol, Marlett, Wingdings2, Wingdings3 and other if they are
available on your system. And keep one column in Arial to see the "real
letter" beside the symbols.

Save this workbook as -say- "charmap.xls" somewhere handy. I use this file
almost every day.

Best wishes Harald
 
Back
Top