Feb 09 2018
01:58 PM
- last edited on
Jul 25 2018
11:01 AM
by
TechCommunityAP
Feb 09 2018
01:58 PM
- last edited on
Jul 25 2018
11:01 AM
by
TechCommunityAP
I have 2 Columns that are time. Example(one column(A) is arrival and the other column(B) is departures) I need them to highlight the row(A2,B2) when the difference between the two is greater than 15. How can I have it highlight the row?
Thanks.
I am running Excel 2016.
Feb 09 2018 09:41 PM - edited Feb 09 2018 09:43 PM
Joshua,
You can use Conditional Formatting with a formula to do that.
But please let us know the kind of difference between the two? Is it greater than 15 hours or minutes?
I'll suppose that is greater than 15 hours, so the formula for the conditional formatting is like this:
=MOD($B2-$A2,1)*24>15
Please find the attachment file to see the solution!
Feb 11 2018 07:26 AM
Feb 11 2018 08:31 AM
=(MOD($B2-$A2,1)*24)>0.25
Feb 11 2018 09:21 AM
thanks again is there a way to have it work for each row of do I have to enter it separate for each row
Feb 11 2018 09:35 AM
In the attached file, the conditional formatting formula is already applied to the whole column A and B, try to add a new record and see how it works.
Feb 11 2018 10:28 AM
awesome it works!! How did you apply the conditional formatting to the columns?
Feb 11 2018 10:46 AM
You have to highlight the target range before you apply the conditional formatting.
You can modify it from the rules manager as the below screenshot: