Hmm, delta normally means the difference between 2 numbers. Based on that, my suggestion would be to select A2:Jxx and apply the two CF rules shown.Is the value in J2 <=2% of the value in H2... if yes color A2-J2 green, if no then red
You're welcome. Thanks for the follow-up.Peter, your formula worked perfectly... thank you again.
That's really because you explanation in post 4 was not mathematically correct.Special K, I could not get your formulas to work in my situation.