Conditional formatting cannot compare across cells
Conditional formatting rules cannot easily compare times, other cells, business days or maxima across ranges.
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
People building Google Sheets dashboards want conditional formatting to react to time windows, to the value in another cell, to the highest value across several rows and columns, and to working days that skip weekends and holidays.
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.