Prev: Switched up to Excel 2007 lost functionality in my array equations
Next: How can I stop format change when copying data into unlocked cells
From: Gino59 on 10 Feb 2010 16:11
Hi!

I have a column of currency values that I'm trying to conditionally format
with the arrow icon set (red, green, yellow). What I'm trying to do is
format the currency value with one of the arrows based on its relation to the
previous cell in the column.

c4 shows $234.22
c5 shows $319.87
c6 shows $111.33
c7 shows $113.24

I would like each cell to show the appropriately colored arrow based on the
previous cell's value. If the cell value is higher than the previous cell
value show a red arrow and if it's less show a green arrow and if equal -
yellow.

A bit stumped and I hope this isn't too stupid a question!!

Thanks
From: Herbert Seidenberg on 10 Feb 2010 21:12
Excel 2007
Arrow Icons
http://www.mediafire.com/file/wgn10kew0n3/02_10_10.xlsx
 | 
Pages: 1
Prev: Switched up to Excel 2007 lost functionality in my array equations
Next: How can I stop format change when copying data into unlocked cells