Hi Guys,

Can anyone help with the following formula, I can write may argument but
cannot get the formula to work?

if cell F5 is 50% or less then Cell G5 = Red
if cell F5 is greater the 50% & less then 75% then Cell G5 = Amber
If cell F5 is greater the 75% Cell G5 = Green


Thanks in advance,

Chris