Forum Discussion
Solved
Conditional Formating Formula
I have two columns with numbers. If the number in B column is higher than the number in A column highlight the cell green If the number in B column is lower than the number in A column highlight...
Hi daniel315
you would need 3 rules for conditional formatting:
Yellow: =AND(B1>=A1*0,9;B1<=A1*1,1)
Red: =B1<A1
Green: =B1>A1
Depending on your regional settings it might be that you need to replace the first formula like this:
=AND(B1>=A1*0.9,B1<=A1*1.1)
Hi daniel315
Just about point 3, you mean if B bigger or small than A within %10.
You need to do three rules in the following order, because there will overlap within the %10
=AND((B1>=A1*0.9),(B1<=A1*1.1)) (yellow)
=B1>A1 (green)
=B1<A1 (red)
- Awesome! Thank you so much, Jihad!
