Icon set based on previous cell's Value

[gallen]

I do a daily stocktake at work. Every day I enter a row of values based on my stocktake.

I've noticed Icon sets and would like to change the icon in relation to the previous day's number. IE. I'd like an up arrow if amount is higher, down arrow if lower and horizontal arrow if the same.

Is this possible? I'm not too bad with VBA if it would need that to achieve it, I just want to know if it's possible.

Thanks

 

[My Aswer Is This]

So if the value in A2 is greater then A1 you want and arrow pointing up.
Is that what you want?

 

[My Aswer Is This]

Look here for help:
Icon Sets in Excel - Easy Excel Tutorial

 

[gallen]

Yes, exactly, thanks.