Conditional formatting rules are too limited and fragile
Conditional formatting cannot compare cells across rows, dates or other cells without long, fragile custom rules.
Tier II · Emerging Problems that are still building up.
4 public reports · first reported 26 November 2019 · last reported 29 April 2026
What's going wrong
Users who set highlight or colour rules in Google Sheets want them to react to other cells, to other rows, or to time windows such as one hour before a set time.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 4 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.