Conditional Formating

I would like to know how to conditionally format cells in the attached excel sheet based off a % variance of the "Goal values"   Cells in column D, E, F are the prescribed goals and Cells in column...