Using an image based on query result

[harryhornet]

Hi All

Is it possible to subtract 2 cells to se if the figure increases, drops or remains the same (this part I can do) however I would like the result to show an image, either an arrow up or down or - mark. How can this be achieved.

Thanks

 

[Fluff]

You'll need conditional formatting for that, have a look here https://www.contextures.com/xlCondFormat03.html#icons

 

[harryhornet]

the only problem that I have with that is that I can get the arrow with winding 3 but I can't seem to get the - symbol to indicate that the figures are the same

 

[Fluff]

In way what way can't you get the -?