KPI Score Color Bands (Green / Yellow / Red)

You're a retail-ops analyst building a stoplight column for a 10-store performance dashboard. Columns A–B contain StoreID and Score (0–100).

The color bands:

Your task:

1. In column C (Color), write a single formula that returns "Green", "Yellow", or "Red" per row.
2. The formula must drag-fill from C2 → C11.

Hint: IFS with descending thresholds is the cleanest pattern — check the highest band first; the first match wins. End with a TRUE catch-all for the lowest band so unexpected values still get a color. Pay close attention to the boundary values — >=80 and >80 give different answers at exactly 80.

Graded cells: C2 (Store A 92 → Green), C3 (Store B 60 → Yellow — low boundary), C4 (Store C 75 → Yellow), C5 (Store D 80 → Green — high boundary), C6 (Store E 79 → Yellow — just below 80), C8 (Store G 55 → Red), C10 (Store I 59 → Red — just below 60).