Help with Conditional Formatting

helen85

Registered User.
Local time
Today, 00:44
Joined
Apr 6, 2007
Messages
33
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. :confused:

I hope some can help me with this matter; it would be very much appreciated.
Thank you :o
 
Ok this is what I have currently:

[Time1].Value<=[Time2].Value

This works, however I need to say [Time1].Value<=[Time2].Value by xAmount for example 4 Minutes. So by 00:04:00

How would I do this?

Thank you
 
Ok, the solution is:
Minute([Time1])>=Minute([Time2]) And Minute([Time1])>=4

This works J
 

Users who are viewing this thread

Back
Top Bottom