Hi

I have a sheet that has "Actual" in B7, "Forecast" in C7 & "Budget" in D7

I want the "Actual" cell to:-

turn green if it is within 5% of the Budget
turn amber if between 5% and 10% of the Budget
turn red if over 10% of the Budget

I cannot get the formulaue right in the conditional formatting

I also have the above repeated in rows 12,17,22,27,32 &37. Do I have to write the formulaes again for each cell?

Thanks in advance