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)
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.
Hi Frank1060
that's a bit tricky because you need to calculate the time difference between current date/time and the date/time of the call.
To do this, you need to combine the date and the time of the call (add them up). Then you can calculate the difference to the current time by using the NOW() function.
The formula in the formatting rule would be:
=AND((NOW()-($A3+$B3))*24*60>40;$C3="Not contacted yet")
In column E you see the time difference in minutes. This column is not important for the solution, it just illustrates how the formula works.
Hope this helps.
Cheers,
Martin