Conditional formatting cannot handle date rules
Conditional formatting cannot easily compare dates to other dates or highlight whole blocks by a monthly total.
Tier II · Emerging Problems that are still building up.
3 public reports · first reported 29 July 2021 · last reported 5 March 2024
What's going wrong
Users want to shade a cell or whole month when a date falls a set number of days after another date, when it comes before the date entered above it, or when a monthly total passes a limit.
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 3 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.