Conditional Formatting Help

Hey guys

Hope all is well,
I am after some serious help, i been trying to find some solutions and so far i have been defeated every corner i have turned, and hoping you guys and provide the solution

1) Aim : Auto adjust “Project Status “ Colour on “Project Status Dashboard” Tab – Update from Green/Amber/Red

Count Plan duration column H on the “Gantt Chart” Tab,
Count Actual Duration column J on the “Gantt Chart” Tab,

If actual Duration column J is between 0% to 5% of Plan Duration column H then GREEN,
IF actual Duration column Jis 6% to 25% of Plan Duration column H then Amber,
actual Duration column J 26% + of Plan Duration column H then RED

Sounds Simple Right ?

Would appreciate any help
The excel sheet might be password protected, if so the password is Miacatalina100

In C3 of "Data" tab use this cell formula (not CF formula!) instead of the dropdown

=LOOKUP(ABS((SUM(tblPlan[Actual Duration])-SUM(tblPlan[Plan Duration]))/SUM(tblPlan[Plan Duration])),{0,0.06,0.25},{"Green","Amber","Red"})