Forum Discussion

EJ_wholesupps's avatar
EJ_wholesupps
Copper Contributor
May 16, 2019

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 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?