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...
=(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?
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: