May 16 2019 02:17 PM
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 J, K, L are the "actual" values, Based off the goal values how would I conditionally format values in column J, K, L to have a red filling if values had a 5% or more discrepancy smaller or greater, and a green fill if within the 5% discrepancy?
May 16 2019 02:28 PM
You may use rule with the formula
=ABS(J3/D3-1)>=0.05
for the red, and
=ABS(J3/D3-1)<0.05
for the green, apply to you range in J:K