I have a MS Access 2010 report that contains a column (fields) of Next Due Dates that are conditionally formatted. When a Next Due Date is within 60 days of the due date, the background color for the field turns yellow. If the date has come and gone (late), the background color for the field turns red. I would like to know if there is an easy way to filter the report so that only yellow and/or red colored items show in the report and all other items (items that are up-to-date) will not show in the report. There doesn't seen to be a way to filter the report by color like you can do in Excel.
Any help with this problem is greatly appreciated. Thanks very much!