Zend certified PHP/Magento developer

Why is row 8 conditional formatting showing an incorrect result?

Using Excel 2019, I created a conditional formatting rule in J4 and applied it to J4:L9. However, J8:L8 is clearly displaying incorrect formatting. If I change A8 from zero to a ‘1’, then row 8 is formatted correctly. What’s happening?

Conditional Formatting Dialog

Spreadsheet with Incorrect Formatting