Forum Discussion
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...
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
SergeiBaklan Thank you so much!!
EJ_wholesupps , you are welcome
