Hi,
I am trying to create two conditions for conditional formatting, but I am not doing something right.
First off, I am trying to set the background of one report field based on the text value of another. The expression I am using in the conditional formatting window is:
[Assigned To] = "Agency" And [due date] = Date()
It is not returning the conditional formatting in the report view.
If I just base it on the value in [due date] it works:
[due date]=Date()
But if I base it on the text value in [Assigned To] then it does nothing:
[Assigned To] = "Agency"
Even when I try to set a conditional format in the [assigned to] field itself, it does not work. In other words if I select " Field Value" "Is Equal To" then use the value "Agency" I do not get a result.
Can anyone help?
Thanks,
Tom
I am trying to create two conditions for conditional formatting, but I am not doing something right.
First off, I am trying to set the background of one report field based on the text value of another. The expression I am using in the conditional formatting window is:
[Assigned To] = "Agency" And [due date] = Date()
It is not returning the conditional formatting in the report view.
If I just base it on the value in [due date] it works:
[due date]=Date()
But if I base it on the text value in [Assigned To] then it does nothing:
[Assigned To] = "Agency"
Even when I try to set a conditional format in the [assigned to] field itself, it does not work. In other words if I select " Field Value" "Is Equal To" then use the value "Agency" I do not get a result.
Can anyone help?
Thanks,
Tom