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 the cell red
If the number in B column is within 10% of the number in A column highlight the cell yellow
What formula would you use?
Thank you!
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!
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)
Martin_Weiss I could use your expertise with an Excel conditional formatting issue. I want to highlight a row in blue if the value in cell L867 remains "Not contacted yet" for 40 minutes. The L column has a dropdown list, and I'm a bit stuck on the formula. Your assistance would be greatly appreciated.
Thanks a bunch!
Hi Frank1060
it's not completely clear to me, what the exact rules should be for your formatting. When you say: "not yet contacted" for 40 minutes:
40 minutes related to what exactly? To a certain record in the list? Which one?
I also propose to put your question in a complete new thread, so it gets more attention by other users.
Cheers,
Martin
- Thank you so much, DTE!
