Conditional Formating

Copper Contributor

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?   

3 Replies

@EJ_wholesupps ,

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

@Sergei Baklan Thank you so much!!

@EJ_wholesupps , you are welcome