Highlight whole rows above a threshold
FormattingMediumDeterministic scoringLatest run
Passed by 10 of 12 products on their best model. Failed: Copilot in Excel and ChatGPT in Sheets.
Prompt
Highlight entire rows where revenue is greater than 10000 with a light green fill.
Starting spreadsheet
Data| A | B | C | |
|---|---|---|---|
| 1 | Date | Product | Revenue |
| 2 | 2025-03-01 | Alpha | 8400 |
| 3 | 2025-03-02 | Beta | 11200 |
| 4 | 2025-03-03 | Gamma | 9700 |
| 5 | 2025-03-04 | Delta | 13800 |
| 6 | 2025-03-05 | Epsilon | 7600 |
| 7 | 2025-03-06 | Zeta | 15100 |
| 8 | 2025-03-07 | Eta | 8900 |
| 9 | 2025-03-08 | Theta | 12800 |
Expected result
Excel and Sheets · All types · All models · All outputs
Pass criteria
All must be met, checked automatically.- A conditional rule
=$C2>10000highlightsA2:C9in light green
Passed 19
Autosheet in Excel Opus 5.5 · Medium
Passed7s · 2¢
Autosheet in Excel GPT-6 Astra · Low
Passed5s · 4¢
Autosheet in Sheets Opus 5.5 · Medium
Passed7s · 2¢
Autosheet in Excel Sonnet 5.5 · Medium
Passed4s · 0.9¢
Claude in Excel Opus 5.5 · High
Passed18s · 11¢
Autosheet in Excel Haiku 5.5 · High
Passed9s · 0.1¢
Claude in Sheets Opus 5.5 · Medium
Passed20s · 4¢
Claude Code + Sheets MCP Opus 5.5 · Medium
Passed32s · N/A
Autosheet in Excel GPT-6.1 Sol · Medium
Passed9s · 1¢
Claude Code + Autosheet MCP Opus 5.5 · Medium
Passed31s · N/A
ChatGPT + Autosheet MCP GPT-6 · Medium
Passed33s · N/A
Autosheet in Sheets Haiku 5.5 · High
Passed17s · 0.1¢
ChatGPT in Excel GPT-6 Astra · Medium
Passed13s · 37¢
Claude in Excel Haiku 5.5 · High
Passed7s · 0.4¢
Claude in Sheets Haiku 5.5 · High
Passed26s · 0.5¢
Autosheet in Excel GPT-6 Luna · High
Passed7s · 0.1¢
ChatGPT + Drive MCP GPT-6 · Medium
Passed34s · N/A
ChatGPT in Excel GPT-6 Luna · High
Passed39s · 0.6¢
Gemini in Sheets Auto
Passed36s · N/A
Failed 3
Copilot in Excel Auto
Failed19s · N/A
Why it failed: No conditional rule on A2:C9.
ChatGPT in Sheets GPT-6 Astra · Medium
Failed27s · 33¢
Why it failed: No conditional rule on A2:C9.
ChatGPT in Sheets GPT-6 Luna · High
Failed17s · 0.3¢
Why it failed: No conditional rule on A2:C9.