Forum Discussion
Conditional Formating Formula
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
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
- Hi Martin_Weiss,
When I need to reach out to a candidate, I have 40 minutes to do so. Once I make contact, I update their status from 'Not Contacted Yet' to another one. Now, what I'm looking for is a rule that says if the status doesn't change from 'Not Contacted Yet' within 40 minutes, the entire row should turn blue automatically.
- Thank you so much, DTE!
