Forum Discussion
Josh Moulton
Feb 09, 2018Copper Contributor
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...
Josh Moulton
Feb 11, 2018Copper Contributor
awesome it works!! How did you apply the conditional formatting to the columns?
Haytham Amairah
Feb 11, 2018Silver Contributor
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: