Overallocation flag in sheets

Is there a formula or method to identify if a resource allocation flag is triggered for a given row?  i.e. have another column in the same sheet that is checked/unchecked or true/false if the "red man" flag is on for a given row? 

I'm trying to figure out if there's a way to summarize all of the rows in our project sheets with resource conflicts so I was thinking if I could add a true/false or checkbox column that could be tied to the red man flag, then I can create a report that would only show rows with the box checked/true.

Hopefully this question makes sense.  Basically, I want a report that would show me all the "red" resource conflicts in the resource management screen.