Forum Discussion
Help with Excel formulas
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...
Joshua,
You can use https://support.office.com/en-us/article/use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f 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!
Hello thanks for helping it is actually 15 minutes. How would that formula look.
=(MOD($B2-$A2,1)*24)>0.25
thanks again is there a way to have it work for each row of do I have to enter it separate for each row
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.