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...
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.
awesome it works!! How did you apply the conditional formatting to the columns?