Conditional Formatting on an Access 2010 Report

[ecalvert47462]

I am using Access 2010 and have a question about conditional formatting on reports.

I currently use formatting on reports and find it is fairly easy to do, however I seem to have stumbled across a scenario that I can't figure out.

I have a very simple query that looks at 4 fields...
Buyer
Dept
PullDate
ShipDate

And I have a query that looks at these 4 fields and then a report is generated based on a date parameter, that the user enters start date and end date, for ShipDate....so that works great and all...but I do have another column that shows up on the report and that is PullDate...which that date range could be either inside the date range selected or outside the date range selected for ShipDate...



Is it possible to conditional format the PullDate column so that the dates are highlighted if they fall within the start/end date selected for ShipDate?

[pbaldy]

You should be able to use Expression Is and use the form or bracketed parameters in it, like this if you used bracketed parameters:

[PullDate] < [Start date] Or [PullDate] > [End date]

using your text of course.