ed,
In A3:
=IF(A1<A2, CHAR(233), IF(A1A2, CHAR(234), CHAR(232)))
Format for Wingdings. I don't think you need to use conditional formatting.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"edver" wrote in message
...
Hello,
I would like to show a trend graphic with arrows.
I don't know a good way to do this so I'm thinking something simple like
cell A1 = 1, cell A2 = 2, and then in cell A3 I want an upward arrow.
So in cell A3 I would have a conditional format that if A1 A2= "downward
arrow wingding"
Can anyone suggest the right wingding or (preferably) a more practical
solution to display an upward or downward trend?
Thanks & Cheers
|