Conditional Formatting Problem (1 Viewer)

PeteB

Registered User.
Local time
Today, 04:07
Joined
Mar 15, 2016
Messages
78
Can anyone help please with a conditional formatting problem?
I have a form where two adjacent fields are 'Requested Date' and 'Response Recd Date', as follows


I want the background colour of the 'Requested Date' field to change where the value of the 'Response Recd' field 'Is Null' and the value in the 'Requested Date' field is <Date()-14.
I would appreciate some help with this. Thanks.
 

Minty

AWF VIP
Local time
Today, 11:07
Joined
Jul 26, 2013
Messages
10,354
Use the Expression option for the Conditional Formatting Tab and enter

Code:
[Requested Date] < Date()-14 AND  [Response Recd] Is Null

As the expression type, then select the colour you require .
 

PeteB

Registered User.
Local time
Today, 04:07
Joined
Mar 15, 2016
Messages
78
Thanks a lot Minty. Your solution worked fine.
 

Users who are viewing this thread

Top Bottom