Crazy question. I have a form where i have set conditional formatiing for certain fields which changes the background color of a field if it doesn't meet certain criteria, signaling me that I need to followup. For example in a Yes/No field, if it's Yes it stays white background, if it's No, the background changes to yellow.

Is it possible to query/report/form to show only records where the fields are displaying the yellow background (perhaps in the form properties?)? I would not need to see a record if there are no fields with yellow. (NOTE: there are several fields for each record set with this conditional formatting and I would need to see the record if it has one yellow background field or five)?

I hope this makes sense to oyu.

Thanks!

Seems you simply need to set the query to use the same logic as the conditional formating rules !? (Or am I missing something here?)

Well you could be right, I DO have a tendency to overthink things. :) I'll check it out.

Thanks!