conditional formatting with with two date criteria's.

[sideoiler427]

Good day all, This is my first time on this forum as a member, spent a lot of time searching but now have a question that I need to ask directly. I am trying to add conditional formatting to a report that has multiple dates in the form that the report is generated from. This is a Contract Review Past Due Report, where I have set the "Review Due Date" ( =Date()+5 ) for review to populate + 5 days from the "Entered Date" ( =Date() ), I have managed to get that to work by it's self, however there is a date field for a QA rep to populate ( QaDate ) when they actually review the contract that I want to incorporate into the formatting. When I run the report ( Between [Start Date] & [End Date]) I want all the "Review Due Date" to show up in RED for all dates that are past due from the +5 days. However once the report shows evidence of someone in QA who has reviewed and entered the date reviewed "Qa Date" I want it to switch the "Review Due Date" back to the default color BLACK... I have tried an number of options and have had no luck, I hope I am explaining this correctly and that someone here can provide some assistance on my issue.



Best regards,

Chris

[June7]

So if the QA date has any value, do not set Review Date as red?

The condition rule would use Expression Is: [Review Due Date]<Date() AND IsNull([QA Date])

[sideoiler427]

okay, I will try that and see where it gets me... thank you!

[sideoiler427]

So if the QA date has any value, do not set Review Date as red?

The condition rule would use Expression Is: [Review Due Date]<Date() AND IsNull([QA Date])

I tried that and now the report results show "error" in the Review Due Date field...

[June7]

You entered that expression into the Conditional Formatting dialog?

Might post an image of what you did.