Conditional Formatting

Summary

Conitional Formatting is not working properly

Content

I have created a report to help our teams identify at risk background checks.  The report uses OBI conditional formatting to change the background to red the data meets certain criteria.  For example, if the candidates does not consent to having their background check run, the field would be bold and highlighted red.  The issue:  Not all fields that meet the criteria are changing.  Does anyone know why this would happen?  Or how to fix?    I have attached both an exported excel version of copy of the report, and an archived version of OBI file. Additionally, there is an image I added to show the discrepancy (note:  not all no's within the selected field are changing to red).