Conditional Formatting not Working For Text on Subreport

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