Hi

I need some tips and advice when it comes to access conditional formatting, The idea is to highlight a textbox (Time1) when one value is bigger than (Time2) by x amount.
Currently in an expression I have: [Time1 >Time2] this works well and highlights the box the conditional formatting is on. However I would like to expand this by making the expression only highlight when for example Time1 is greater than Time2 by 5miuntes.
Both Time value text boxes are formatted like hh:mm:ss
So it would be something like: [Time1 >Time2] + 00:05:00.
I hope some can help me with this matter; it would be very much appreciated.
Thank you

I need some tips and advice when it comes to access conditional formatting, The idea is to highlight a textbox (Time1) when one value is bigger than (Time2) by x amount.
Currently in an expression I have: [Time1 >Time2] this works well and highlights the box the conditional formatting is on. However I would like to expand this by making the expression only highlight when for example Time1 is greater than Time2 by 5miuntes.
Both Time value text boxes are formatted like hh:mm:ss
So it would be something like: [Time1 >Time2] + 00:05:00.

I hope some can help me with this matter; it would be very much appreciated.
Thank you
