Retrun Entry based upon 3 different cells (traffic lights)

[halfpint123]

Hi

Putting together a KPI spreadhsheet with tragets and thresholds. One colum has the monthly figuer, the next the target, then 3 threshold figuers for a traffic lights, gold, green,1.xls red. I want a f1.xlsormula to return if the current montly figuer is red, green, gold.

Spreadsheet attached.

Please help.

thanks

[DBY]

Hello
See the attached file. It has a formula to return the name of the threshold colour and conditional formatting to reflect the value.

Hope this is what you're looking for.
DBY

[halfpint123]

Gret, just one problem if it falls below 80 should be red as well, how can I change? Thanks

[halfpint123]

i mean falls below the red threshold

[halfpint123]

=if($c8>=$x8,"gold",if($c8>=$w8,"green",if($c8<=$w8,"red","")))

[DBY]

Hi
Glad it worked. Change the formula in cell H2 to the following:

=IF($C2>=$G2,"GOLD",IF($C2>=$F2,"GREEN","RED"))

Anything under 93% should now return RED.
DBY