Conditional Fortmatting - Time before Now()

[Spud33]

I currently use a report that is continually displayed, it refreshes its data evrey 5 mins. The purpose of the report is to display when we are required to send various updates about a product.

I cuurently have 2 criteria selected within condictional formatting for that field as follws:

Field value is less than Now() = Red Back Ground
Field value is greater than Now() = Green Back Ground

The above works fine, I now wish to add a further critria where when it reaches 15 mins before Now() will display the background as orange, then when it reaches Now() wil diplay Red as it currenly does.

I have tried numerous ways of trying to get this to function but is only meeting one or the other criteria stated, reslting in continually going round in circles.

Any assistance would be greatly appreciated and I will probably kick myself on the solution, thanks in advance

Spud

 

[Cronk]

The conditional testing is done in sequence.

If you first test for < Now and then test for < Now -15 minutes, the second conditional format will never be applied.

 

[Spud33]

Thanks for putting me on the right track, having got so involved in trying to get this to function, forget all about conditional formatting rules, sometime you just need bringing back to earth!
Have now got it to do what I need by doing the following:
Value <Now() = Red Background
Value Is Between Now() and Now()+(0.25/24) = Orange Background
Value >=Now()+(0.25/24) = Green Background