Rules cannot reliably use values from other tabs
Conditional formatting cannot reliably compare cells against values on another sheet or tab.
Tier I · Proven The best-established problems.
10 public reports · first reported 19 September 2018 · last reported 19 January 2025
What's going wrong
Users want formatting rules that check a cell against a value on another tab or in another spreadsheet, such as a reference list, a stock master, or a roster.
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 10 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.