PDA

View Full Version : Traffic lights - Increasing/Decreasing Trends



manu_grim
08-07-2014, 04:32 AM
Hello,


I need a piece of code to:
-return red/yellow/green when the value is below/above or within range of targets but dependent on an increasing or decreasing trend.
If the trend is decreasing and the value is above the target is should return red.
If the trend is increasing and the value is above the target is should return green.
For all there is a Threshold.


For example:
Value Target Trend TrafficLight
(A) 79% 90% Increasing RED
(B) 69% 70%-90% Withing Range Yellow
(C) 85% 90% Decreasing Green


Thresholds:
for example (A) - Red: <80%, Yellow: 80%-90%, Green: >90%
for example (B) - Red: 60-90%, Yellow: 50-60%;90-95%, Green: <50%;>90%
for example (C) - Red: >80%, Yellow: 80-90%, Green: <90%


Thank you very much!!!

Bob Phillips
08-07-2014, 04:54 AM
Same reply that you got at ExcelGuru.

Aussiebear
08-09-2014, 02:59 AM
Just for interest sake, what reply did you receive from Excelguru???.

Bob Phillips
08-13-2014, 02:20 AM
http://www.excelguru.ca/forums/showthread.php?3348-Traffic-lights-Increasing-Decreasing-Trends