linking clip art to a formula in excel

[Guest]

suppose A1 cell is having no. = 5
a2 = 6
i want to automatically get an image in A3 tht ^ (not this image but an
image of an arrow from clip art positioning upward ) meaning that six is
greater. its common in investments. when price goes up. automatically upward
arrow should appear.

Vice versa when A1 = 6
A2 = 5
then in A3 downward showing picture should come meaning .price of share has
gone down.
how do i do this in excel sheet. please mail me abt this topic.
Rgds
yusuf

 

[Guest]

Hi

Use an IF formula and format the cell as Wingdings3. You can then use i and
h - which will give you the necessary arrows eg:
=IF(A2>A1,"i","h")

Andy.

 

[Guest]

Little arrows are difficult to read on a large spreadsheet.........have you
considered conditional formatting to color the cells differently for each
condition?

Vaya con Dios,
Chuck, CABGx3