Apply conditional formatting rules

I need conditional formatting that flags three failure modes on the sheet Forecasts: red fill for any row where Actual < 90% of Forecast, amber fill where Actual is between 90% and 98% of Forecast, and green fill where Actual ≥ 98% of Forecast. Apply the rules to the Actual column for rows 5 through 10,005 and ensure the rules are ordered so no row ends up with multiple colors. Test on a sample of edge values before I send the file to the planning team. Ladder":"L1"

Before I publish the forecast workbook to the planning team, make their review fast: add a leftmost column that shows a single-word status Good, Watch, or Bad based on the conditional rules, ensure the color rules and the status column always agree, and add a rule to highlight any blank Actual cells so they are visible. Also document in one sentence how the thresholds were chosen. Ladder":"L2"

I applied three conditional rules and some rows show no color or the wrong color. The planning lead will blame me for sloppy logic. I’m not sure whether the rule order, absolute vs relative references, or range selection is at fault. What are the likely causes and the step-by-step fix to make the intended single color appear consistently? Ladder":"L5"

We keep spending time each month fixing conditional formatting that behaves inconsistently when ranges change or new rows are inserted. Which two habits around rule design and workbook layout will stop this recurring issue and make conditional rules resilient so I don’t have to reapply them each period? Ladder":"L6"