ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Up/down arrows to show trends (https://www.excelbanter.com/excel-discussion-misc-queries/171339-up-down-arrows-show-trends.html)

Limarah

Up/down arrows to show trends
 
I would like to should up/down indictors to demonstrate a quick visual cue as
to whether the figue is up or down on last year. I have played around with
the conditional formatting and owrked out how to change the cell writing to a
different colour to show a trend.

Does anyone know how I can demonstrate this with triangle images (red for
bad green for good).

CLR

Up/down arrows to show trends
 
The Wingding and Webding fonts have various arrows, triangles, etc which
combined with conditional formatting, etc might do as you want.

Vaya con Dios,
Chuck, CABGx3


"Limarah" wrote:

I would like to should up/down indictors to demonstrate a quick visual cue as
to whether the figue is up or down on last year. I have played around with
the conditional formatting and owrked out how to change the cell writing to a
different colour to show a trend.

Does anyone know how I can demonstrate this with triangle images (red for
bad green for good).


Limarah

Up/down arrows to show trends
 
They are to demononstrate Key Performance Indicators

"Limarah" wrote:

I would like to should up/down indictors to demonstrate a quick visual cue as
to whether the figue is up or down on last year. I have played around with
the conditional formatting and owrked out how to change the cell writing to a
different colour to show a trend.

Does anyone know how I can demonstrate this with triangle images (red for
bad green for good).



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com