Hi All
I have a form in Datasheet view.
I have two conditional formatting conditions I would like to use on all the records in the form.
First is
Expression: [Added TimeStamp]>Date() - Color in text as BLUE
Second is
Expression: [Expected Arrival Date]<Date()+7 - Color in text as RED
The thing is, that both these conditions can be true at the same time, what I would ideally like to do is use a If statement or something like in VBA it would look something like this as an idea:
Code:
If [Expected Arrival Date]<Date()+7 = True
Color text as Red
Else
If [Added TimeStamp]>Date() = True
Color text as Blue
Else
Leave color as default
End If
So, the second expression takes priority so all EAD<Date()+7 will be RED, if not then it might be BLUE if AddedTime>Date(), if both are not true then it will be left as default.
Any ideas on how to do this?
Thanks