Excel IF Logic & Formatting Help

I’m trying to tighten up the logic that drives several conditional-formatting rules in my workbook, but the combination of IF, IFERROR and deeper nested tests keeps throwing unexpected results. The task is to step into the sheet, examine each of these logical formulas, and adjust or rebuild them so every rule fires exactly when it should.

You’ll receive a copy of the file with my current attempts already in place. I’d like you to:

• Trace the existing IF / IFERROR chains, identify the break points, and correct them
• Simplify any needlessly nested statements while preserving the intended outcome
• Ensure the final formulas cleanly return the TRUE/FALSE output conditional formatting relies on
• Add concise, in-cell comments or a short write-up so I understand the fix and can maintain it later

Please work directly in Microsoft Excel (Office 365 preferred) and return the revised workbook plus your explanation. I’m ready to get this resolved right away.