Excel users can't auto-color cells by date or checkbox status.
Repeated problem · 90-day evidence
Who experiences it
Tracker builders in Excel — order/shipping coordinators logging orders by date, trainers tracking trainee progress with dropdowns and checkboxes, and teams migrating from Smartsheet — who need cells to self-color from dates, dropdown selections, or checkbox states.
Workflow
They build a row-based tracker (date ordered/shipped, customer, trainee status, checkbox columns), open Conditional Formatting, and hand-write formula-based rules per trigger (weekday, working-day comparison between two date columns, dropdown value, checkbox). They test and re-edit formulas when colors don't appear or don't update after data changes, often asking for step-by-step help.
Possible direction
A visual plain-English conditional-formatting rule builder (taskpane add-in or wizard) that converts natural rules — "fill red when date is 7 working days after column B," "color by weekday," "fill when dropdown equals X or checkbox is checked" — into correct Excel conditional formatting rules.
Current context
Excel's native Conditional Formatting with formula-based rules plus Data Validation dropdowns remains the standard approach, and tutorials exist for row coloring by dropdown selection; some formatting taskpane add-ins exist, but users still hand-author formulas and repeatedly request help, including those coming from Smartsheet's simpler conditional formatting.
Observed from 3 distinct users across 3 discussion threads in the 90 days ending 2026-08-13. Latest evidence: 2026-08-04.
Keyword suggestions